ODBC Woes

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,
MikeInstalling MDAC should fix this.
If it doesn't, you can try running the following command from a command
prompt (in your c:\windows\system32 directory):
odbcconf.exe /F odbcconf.rsp
That should rebuild your registry (try renaming or deleting the existing
\Software\ODBC key first).
Note: this is not supported by Microsoft. This is the same command that
MDAC setup will run on your machine, but it is not "officially" intended
for use outside MDAC setup.
Brannon
Mike McIntyre wrote:

> 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 (Windo
ws
> 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
>
>