Hello,
I am a newbie. Need help with SQL Server. Right now I want to add a databaseconnection to the SQL Server. Currently, the only connections that show up are the connections that came with installation (like pubs and northwind dbs). I want to add a new connection based upon a microsoft access dB that I created. Is there some type of connection Manager? Anyway, here is an example to simplify my question:
I have a Microsoft Access dB that I just created. I now want to allow SQL Server to connect to it so that I can use the dB in my code. However, Access saves my new dB as a Access file in some directory, not as a .mdf file that VB.Net and SQL Server can recognize. The server doesnt know that it exists: how do I get server to establish the connection?
I tried playing around with the "Export" function within Access. Didnt help much.
Doesnt it seem like this should be more straightforward? I am sure that this is a very common problem for newbies to solve.
Thanks for the help
I am a newbie. Need help with SQL Server. Right now I want to add a databaseconnection to the SQL Server. Currently, the only connections that show up are the connections that came with installation (like pubs and northwind dbs). I want to add a new connection based upon a microsoft access dB that I created. Is there some type of connection Manager? Anyway, here is an example to simplify my question:
I have a Microsoft Access dB that I just created. I now want to allow SQL Server to connect to it so that I can use the dB in my code. However, Access saves my new dB as a Access file in some directory, not as a .mdf file that VB.Net and SQL Server can recognize. The server doesnt know that it exists: how do I get server to establish the connection?
I tried playing around with the "Export" function within Access. Didnt help much.
Doesnt it seem like this should be more straightforward? I am sure that this is a very common problem for newbies to solve.
Thanks for the help