SQL linking to database in XP

15 pts.
Tags:
Database
ODBC
SQL
Windows XP
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Most common beginner problem is – In the ServerHost box did not try ‘localhost’ and in Username did not try ‘root’.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Squashjunkie
    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?
    325 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following