Feb 12 2005, 01:47 PM
Can somone give me a detail on how to connect to 2003 Microsoft Desktop SQL via access?
I have intsalled desktop SQL.. it is running in the taskbar, but i have had no training in any classes on how to connect.
Any help would be greatly appreciated, even a link to a tutorial.
Feb 12 2005, 02:01 PM
You can create a Access Project (adp) and use the connection to connect or you can link an Access Database (mdb) using ODBC. You will need to create a dsn and then link to the tables and views.
Feb 12 2005, 02:09 PM
OK.. Thank you truittb
Created Access Database Project..
but what if the server is not loacted in the drop down bar?
and what is a dsn?
Edited by: techwizz on Sat Feb 12 14:10:21 EST 2005.
Feb 12 2005, 02:22 PM
Is SQL server actually running? Hover your mouse over the Icon in the system tray. Does it say Running - \\YOURSERVERNAME -MSSQL Server
If it is running, try entering the server name directly in the dropdown box on the Connection Dialog box.
A DSN is as Data source file. This simple way to create one is to goto File, Get External Data, link, the on the Files of Type drop down select ODBC Databases and then use the wizard to create the DSN.
Feb 12 2005, 02:26 PM
Get external data.. i will try that in a bit.
I have to drive somewhere. I will be back..
Yes its running in the bottom right.
and thank you.. its much easier to learn from someone than to do it yourself.. google is my buddy and all, but he never answers my direct questions...lol
Thanks Again truittb
Feb 12 2005, 02:34 PM
You are welcome.
Feb 13 2005, 06:19 PM
Good deal.. that did the trick.. had to type the Server in by hand.
One more question if anyone reads this.. what is the data type for a autonumber in SQL server...
in both access and MySQL it is autonumber.. but i not see it in Microsoft SQL?
Feb 13 2005, 06:31 PM
You are welcome.
Use int and uncheck the allow nulls and then set the Idenity property to Yes.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here