ADO.NET-GET ERR MSG WHEN CONN TO *.MDF WITH MSDE

[TNN]

Learning ADO.NET (novice)

Trying to connect to *.mdf database using conn object on form in vb.net. Get err msg when test conn "Test connection failed" saying I am "Not associated with a trusted SQL server connection" I am trying to connect to a database in the ..\microsoft sql server\..directory. Using the MSDE provided in Visual Studio.

What's happening?? How do I become a "trusted SQL server connection?? Any comments or help is appreciated.

TNN, Tom



TOM

http://WWW.TNPAYROLL@AOL.COM

 

[Al42]

Any particular reason you're trying to connect to the .mdf, rather than to the database? (Your connect string should be set up for SQL, not Access.)

 

[TNN]

AI42,
Isn't the .mdf the database ????

I do have the conn tab set up for Microsoft oledb provider for SQL server.
TNN, Tom



TOM

http://WWW.TNPAYROLL@AOL.COM