Thread: can not connect to msde
View Single Post
  #2 (permalink)  
Old February 4th, 2004, 10:33 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
  
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default
Did the book say you needed to set Initial File Name to the name of the.MDF file for a SQL Server connection?

Take a look here to see how your connection should look: http://www.able-consulting.com/MDAC/...erForSQLServer

Basically, what you need are: Data Source and Initial Catalog. Data Source should be set to the named instance of your MSDE installation. So, if your server is called YourServer, and you named the instance of MSDE YourInstance, your Data Source should be YourServer\YourInstance. The Initial Catalog is the name of the database you're trying to connect to.

The part about Initial File Name can be removed.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.