UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Connecting to installed desktop sql    
 
   
techwizz
post Feb 12 2005, 01:47 PM
Post #1

UtterAccess Enthusiast
Posts: 80
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.

Thanks UtterAccess!

Mike Koenig
Go to the top of the page
 
+
truittb
post Feb 12 2005, 02:01 PM
Post #2

Retired Moderator
Posts: 13,544
From: Texas (Is there anywhere else?)
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.
Go to the top of the page
 
+
techwizz
post Feb 12 2005, 02:09 PM
Post #3

UtterAccess Enthusiast
Posts: 80
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.
Go to the top of the page
 
+
truittb
post Feb 12 2005, 02:22 PM
Post #4

Retired Moderator
Posts: 13,544
From: Texas (Is there anywhere else?)
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.
Go to the top of the page
 
+
techwizz
post Feb 12 2005, 02:26 PM
Post #5

UtterAccess Enthusiast
Posts: 80
Ahh.. ok

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
Mike Koenig
Go to the top of the page
 
+
truittb
post Feb 12 2005, 02:34 PM
Post #6

Retired Moderator
Posts: 13,544
From: Texas (Is there anywhere else?)
You are welcome.
Go to the top of the page
 
+
techwizz
post Feb 13 2005, 06:19 PM
Post #7

UtterAccess Enthusiast
Posts: 80
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?

Thanks
Go to the top of the page
 
+
truittb
post Feb 13 2005, 06:31 PM
Post #8

Retired Moderator
Posts: 13,544
From: Texas (Is there anywhere else?)
You are welcome.

Use int and uncheck the allow nulls and then set the Idenity property to Yes.
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 26th May 2013 - 02:32 AM