Home > IT Answers > Microsoft Windows > SQL linking to database in XP
Help

Question

  Asked: May 2 2008   2:33 PM GMT
  Asked by: Bigblew

SQL linking to database in XP


Windows XP, SQL, ODBC, Database

First of all, I tried to create an ODBC connection to a local SQL database.
It successfully created but it does not show up. I know it is there because
I can link to it via Access or if I try to create the same one again, it
tells me it is already there and if I want to overwrite it.

In trying to resolve this myself, I have tried to make sure my machine has
all it's updates. I found that there are many updates not applied, nor will
they apply. For some reason they are failing to apply. I reinstalled XP
and this has done nothing.

Before I went to the extreme of reformatting it, I wanted to check with you
first to see if you can offer any suggestions.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: May 5 2008  2:07 PM GMT  by Nozlop




Most common beginner problem is - In the ServerHost box did not try 'localhost' and in Username did not try 'root'.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Microsoft Windows, Development and Database.

Looking for relevant Microsoft Windows Whitepapers? Visit the SearchWinIT.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Squashjunkie  |   May 6 2008  1:52PM GMT

Sounds like a rights issue on the client (XP workstation) you are using. If you created the ODBC connection, was it a User, System or File DSN? This will have an impact when you try and use trhe connection, depending on where you have it set up.
Also what type of user are you on the XP workstation? Do you have full administrative rights, or are you on a domain, logged in as a user with limited rights?