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:
Software/Hardware used:
ASKED:
May 2, 2008 2:33 PM
UPDATED:
May 6, 2008 1:52 PM
RELATED QUESTIONS
- How to add and / or delete files to modify a program's installation?
- A question about links not updating correctly via Dreamweaver templates...
- What's the best way to check for updates in my program?
- Auto-Populate an Access form using a table of values
- Need help setting Transaction Log properties in SQL Server 2000
Answer Wiki:
Most common beginner problem is - In the ServerHost box did not try 'localhost' and in Username did not try 'root'.
To see all answers submitted to the Answer Wiki: View Answer History.
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?