So today at work, we ran into a problem with System DSNs just walking off of some computers. After checking out the interwebs, I came across some forum posts covering the issue. Here's what we had to do to restore the System DSNs that went missing:
Open up regedit and browse to
HKLM\SOFTWARE\ODBC\ODBC.INI
Then look for ODBC Data Sources key... if it's not there, that's what your problem is.
Recreate the ODBC Data Sources key then add Strings for each of the ODBC connections that is showing under the ODBC.INI key. You will have to assign the driver name to each of the Strings you just created. For example, I created a TESTDB String (which is also a key under ODBC.INI) in the ODBC.INI key. Then the value I assigned to it was SQL Server. The SQL Server value is the driver name. The driver names can be found under the ODBCINST.INI key right below ODBC.INI.
No comments:
Post a Comment