sql server odbc:
I am a programmer but I have many years of experience with Sql Server from
6.5, 7, and 2000 versions.
I have a problem I have never seen before, the first I have been unable to
resolve myself.
After installing the latest Micrsoft Windows XP patches (issued this past
month) and rebooting the Sql Server 2000 on my development computer (Windows
XP SP1) failed to start.
After trying for several days to resolve the situation I decided to
reinstall Sql Server 2000. I also reinstalled MDAC.
Once I was done the Sql Server tried to boot but gave the message ... does
not exits or permision denied.
I went to check ODBC keys in the registry and they are corrupt. Some are
missing and some have bad values.
Is there a tool or article that will help me rebuild the keys? I tried
various aricles all day today but none seems to relate to the problem I
have?
Some other symptoms:
From ODBC Data Source Manager:
I can seem previously setup DSNs.
If I try to Romove or Configure an existing DSN one I get this error:
"The Setup Routine for Sql Server ODBC Driver could not be found. Please
reinstall the driver."
I click OK and get a Windows titled: "Driver's ConfigDSN, ConfigDriver, or
ConfigTranslator failed." In the window is the message: "Component not
found in the registry."
If I try to add a DSN the Create Data Source windows opens but NO drivers
are listed.
Thank you,
Mike