I am trying to do the Chapter 1 project of Getting Started with ADO.net 2.0 Step by Step (microsoft press)...
I enter the data source configuration wizard and select database, and press next.
I then press the new connection button, and the Choose data source screen appears.
In the List are only 2 options:
Microsoft Access Database File
Microsoft SQL Server Database File.
The option they want me to choose does not appear in the list.
Microsoft SQL Server sqlclient
I tried following the instructions in this thread [http://forums.microsoft.com/msdn/showpost.aspx postid=85686&siteid=1] where a user had a similar problem, but had no success.
I have reinstalled C#, reinstalled SQL Server Express 2005 with Advanced Tools, but neither helped.
Any help would be greatly appriciated.
sao123
Microsoft SQL Server is missing from the DataSource dropdown, cant connect to a SQL Server Express Database.
IamHuM
Byenary
Hi sao123,
"Microsoft SQL Server Database File" is the same as "Microsoft SQL Server sqlclient", I think that may be a typo on behalf of Microsoft Press!
Scott
Tigers21
I dont think so.
Microsoft SQL Server Database file allows you to connect to a pre-created mdf/ldf file combination.
Connecting with Microsoft SQL Server Client, is supposed to connect you to a SQL server to use the SQL browser to look at all the databases on a given SQL server, especially when connecting to databases on a remote server.
tutto_24
Hi sao123,
The Express Edition of C# 2005 only allows connections to *.mdb or *.mdf files, that C# will attempt to include a copy of locally in your solution. Having not read the book that you mentioned above, I (stupidly) assumed that this was a C# Express book (sorry for the error on my behalf).
But this still does not explain why you can not connect to a SQL Database.
Have you tried adding one directly to you solution, and then using the wizard that way.
Scott