15 pts.
 SQL linking to database in 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.

Software/Hardware used:
ASKED: May 2, 2008  2:33 PM
UPDATED: May 6, 2008  1:52 PM

Answer Wiki:
Most common beginner problem is - In the ServerHost box did not try 'localhost' and in Username did not try 'root'.
Last Wiki Answer Submitted:  May 5, 2008  2:07 pm  by  Nozlop   90 pts.
All Answer Wiki Contributors:  Nozlop   90 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

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 pts.