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.