• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 332
  • Last Modified:

SQL 2005 Demo, ODBC connection

I have installed SQL 2005 Demo on a win serv 03' box. From the server I can create a ODBC connection using my network admin account. I cannot create a odbc connection from a desktop. (ie. a machine with MS Access)

I am trying to import the table structure from an old SQL DB for use in a new Access application.

Any advise would be appreciated.
0
pwanveer
Asked:
pwanveer
1 Solution
 
devsolnsCommented:
Make sure that you allow remote connections with 2k5.....http://support.microsoft.com/default.aspx?scid=kb;en-us;914277



Then connect with this connection string: (http://www.connectionstrings.com/)

"Driver={SQL Native Client};Server=tcp:192.168.1.100, 1433;Database=pubs;UID=sa;PWD=asdasd;"

Make sure to replace the ip with the ip of the server.

Hope this helps.

--DS
0
 
pwanveerAuthor Commented:
That's got it! Thank you sir!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now