April 2005 - Posts

is the Tablet PC idea dead?

I have a Fujitsu Siemens T3010 tablet PC. I love the tablet for traveling, speeches and at home. ( In office use a mega 17 inch notebook from acer)

Now i search for a new tablet. My tablet is two years old and the battery live shrinks. So i want to do some for the economy and buy new one. But i am surprised. Seems that only three trades are left in the market, HP, Acer and Fujitsu Siemens. The models look quite old.

What i need

  1. good display not more than 12 inches ( also for outside usage)
  2. 5 hours ore more battery
  3. less that 1,5 kg
  4. dsiplay turnable (tablet and keyboard mode)
  5. Wireless blabla
  6. price dosnt matter

Do you have any tipps for me. What device do you use and why?

 

Posted by preishuber | 8 comment(s)

Tool of the day: Insert snippet

i am actualy in the situation that i must change fast a asp page to aspx. This page should sends a email.

Because i am lacy and dont like writing lines of code i had the idea to use the new snippet manager of Visual Studio 2005. Right Click-insert snippet-connectivity and network-send a email message- now i have my code-

Dim email As New MailMessage()
email.To =
"RecipientAddress"
email.From = "SenderAddress"
email.Body = "MessageText"
email.Subject = "SubjectText"
email.BodyFormat = MailFormat.Text
SmtpMail.SmtpServer =
"SmtpServerName"
SmtpMail.Send(email)

The only problem is that visual Studio 2005 marks at the same time this code as obsolete. And its true;-) The correct code should be someting like this

Dim myMail As New Net.Mail.SmtpClient
myMail.Host = "localhost"
myMail.Port = 25
myMail.Send("
asp@ppedv.de", "hannesp@ppedv.de", "Betreff", "Nachricht")

 

 

Posted by preishuber | with no comments

Beta Experience for EMEA

If you are citicen of EMEA (European, middle East and Africa) you can get now for 10 Euros your Beta Kit. Ordering is available for passport account owners here

http://www.microsoft.com/emea/msdn/betaexperience/deat/order.aspx

If you are from another region use that link http://www.getthebetas.com

EMEA seems to be behind the rest of the world.

[UPDATE] i got an update from the EMEA team that the DVD is free, except in germany[/UPDATE]

Posted by preishuber | 5 comment(s)

Manage SQL Express with SSEUTIL

It seems microsoft loves to have more than one tool to do the same job. Actualy i can use OSQL, SQL Express Manager and Visual Studio. Now i have found a new tool: SSEUTIL.

http://go.microsoft.com/fwlink/?LinkId=44178

This is a command line tool. You can eg attach and detach a database. Intresting command is LIST which shows all attached databases.

Posted by preishuber | with no comments

Miss SQL Server Management Studio?

I installed the SQL Server 2005 April CTP, which i got from the betaplace. The download size is approxiamtly 560 MB. You have to unzip this file (also ISO image available) and run setup.

After the setup i missed additional management tools like SQL Server Management Studio.

The reason must be a prior installation of SQL Express which is included in Visual Studio 2005 BETA2.

I uninstalled from the software panel the Microsoft SQL Server 2005 tools expression edtion ctp and run the setup from SQL Server 2005 again. Now it works. My menu have now several new entrys.

 

Posted by preishuber | 3 comment(s)

Attach and Detach a SQL Express Database

My weblog audience knows my relation to SQL Express. Now i have some good news. I think i have understood the way how to attach databases in SQL Express.

  • SQL Express databases are stored in files with the MDF extension.
  • The database is automaticly mounted if an application need it. This is controled by the AttachDBFilename keyword in the connection string.
  • Their must be an automatic detaching mechanismus if the db is no longer used. I didnt find any details till now.
  • You can attach (mount) a database by hand using tsql commands. Starting OSQL and typing

1> sp_attach_db "northwind", "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQ
L\Data\Northwind.mdf"

  • this attaches the database for ever. With sp_detach_db followed by the "alias" you unmount the database.

1> sp_detach_db pubs

Hope this helps you. Now i see a little bit clearer. Also SQL Express Manager can use such attached database.

Posted by preishuber | 4 comment(s)

I HATE IT, I HATE IT, I HATE IT : SQLEXPRESS

1> use northwind
2> go
Msg 911, Level 16, State 1, Server XP-PRE3A\SQLEXPRESS, Line 1
Could not locate entry in sysdatabases for database 'northwind'. No entry found
with that name. Make sure that the name is entered correctly.
1> use pubs
2> go
Msg 945, Level 14, State 2, Server XP-PRE3A\SQLEXPRESS, Line 1
Database 'pubs' cannot be opened due to inaccessible files or insufficient
memory or disk space.  See the SQL Server errorlog for details.

Done by OSQL. The ERRORLOG is not updated. (located in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG)

And why (to hell) is this file without an extension? To enshure nobody can make notepad default editor? NONSENSE! ( yes i know was the same in earlier versions like sql server 2000)

Surprising fact: with visual Studio 2005 database project i can open the PUBS.MDF and NORTHWIND.MDF. Also view and edit the data.

My next station was the SQL Express Manager which is available as newer build for SQL Express April CTP which is shipped with Visual Studio 2005 Beta 2.

http://lab.msdn.microsoft.com/express/sql/

I see in the list (under databases) the pubs database with status shutdown and not the northwind. I tryed to start a sql command like select * from authors. Got an error

Database 'pubs' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details. (.Net SqlClient Data Provider)

Also nonsense, the error is not logged.

Everything done with integrated security.

Subject=Summary

[UPDATE]

I have uninstalled a deactivated ISA Client and now i have new error message and partial success

1> use pubs
2> go
The Service Broker in database "pubs" will be disabled because the Service
Broker GUID in the database (27968DAA-A052-4A1C-98A3-229A3EC0B3CC) does not
match the one in sys.databases (74E4B7CB-BEFA-4A0E-A2B5-654B0DA96553).
1> select * from authors
2> go
 au_id       au_lname                                 au_fname
        phone        address
        city                 state zip   contract
 ----------- ---------------------------------------- --------------------
        ------------ ----------------------------------------

When i open pubs with visual studio i can not access at the same time pubs with osql

1> use pubs
2> go
Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\
MSSQL\DATA\pubs.mdf". Operating system error 32: "32(Der Prozess kann nicht auf
die Datei zugreifen, da sie von einem anderen Prozess verwendet wird.)".Unable t
o open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DA
TA\pubs_log.LDF". Operating system error 32: "32(Der Prozess kann nicht auf die
Datei zugreifen, da sie von einem anderen Prozess verwendet wird.)".Msg 945, Lev
el 14, State 2, Server XP-PRE3A\SQLEXPRESS, Line 1
Database 'pubs' cannot be opened due to inaccessible files or insufficient
memory or disk space.  See the SQL Server errorlog for details.
File activation failure. The physical file name "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\pubs_log.LDF" may be incorrect.

The reason is once again the diffrent security credentials which are used to start SQLExpress. I have two instances running. One with Network service and one with admin accout.

 

 

Posted by preishuber | 3 comment(s)

Microsoft .NET Framework SDK QuickStart Tutorials Beta 2 installation fails

In the menu you can find the entry Quickstart Tutorials ( unter SDK). This are a great tutorial to learn small topics on ASP.NET 2.0 . If you have installed prior the quickstarts your setup may fail on the database creation step.

The reason could be a left MDF file eg for the Membership ect called aspnetdb. You find it here

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

Simply delete it.

The setup also try to install northwind and pubs.

You can find the full description of errors in configsampleslog.txt

If you want to setup the quickstarts database by hand following command should help

aspnet_regsql.exe -S (local)\SQLEXPRESS -E -A all

Posted by preishuber | with no comments

Now its Out: Reason for delay of ASP.NET 2.0 book

It is (again) a small delay of my ASP.NET Beta 2.On my book are 2 DVDs with the B2 bits included. And the bits are not ready yet. So the production of the DVDs must wait... and my book is late

http://www.microsoft.com/emea/msdn/betaexperience/

 

Final date is 25 of April for first download possibility.

Posted by preishuber | 2 comment(s)

ASP.NET 2.0 Crash Course Book delayed :-(

My book ASP.NET 2.0 crash course (MS Press) is delayed from end of april to mid of may.

Dont ask me why!

http://www.amazon.de/exec/obidos/ASIN/3860635328/qid=1112708612/sr=8-1/ref=sr_8_xs_ap_i1_xgl/028-7174995-1237354

 i have finished my work in time

Posted by preishuber | 2 comment(s)
More Posts