CrimeScene
IS-IT--Management
- Jul 5, 2003
- 59
- 0
- 0
In reference to closed thread: thread706-384881
and regarding this similar post:
I have not yet determined how this occurs but when the following value is blank, all of the existing ODBC configurations become COMPLETELY HIDDEN from the user –- whether using the ODBCAD32.EXE tool or when any application prompts the user with a list of pre-configured ODBC connections that truly do exist on their local computer.
1. Open REGEDIT.EXE
2. Navigate to HKLM > SOFTWARE > ODBC > ODBC.INI > ODBC Data Sources
3. In the right pane, the entry “(Default)” has a Data value of blank.
I am able to manually resolve this issue:
1. Simply right-click the “(Default)” entry and choose delete. After confirming deletion, the system will immediately recreate that REG_SZ entry … only this time properly setting its value to “(value not set)”.
2. Refresh the ODBCAD32.EXE window and all of the ODBC configured connections reappear.
This occurs on many of our machines running WinXP SP2.
I would like to be able to automate the correcting (change or delete) of this registry value, using WSH scripting, but I do not know how to manipulate that particular entry. Any suggestions?
Thanks!
and regarding this similar post:
I have not yet determined how this occurs but when the following value is blank, all of the existing ODBC configurations become COMPLETELY HIDDEN from the user –- whether using the ODBCAD32.EXE tool or when any application prompts the user with a list of pre-configured ODBC connections that truly do exist on their local computer.
1. Open REGEDIT.EXE
2. Navigate to HKLM > SOFTWARE > ODBC > ODBC.INI > ODBC Data Sources
3. In the right pane, the entry “(Default)” has a Data value of blank.
I am able to manually resolve this issue:
1. Simply right-click the “(Default)” entry and choose delete. After confirming deletion, the system will immediately recreate that REG_SZ entry … only this time properly setting its value to “(value not set)”.
2. Refresh the ODBCAD32.EXE window and all of the ODBC configured connections reappear.
This occurs on many of our machines running WinXP SP2.
I would like to be able to automate the correcting (change or delete) of this registry value, using WSH scripting, but I do not know how to manipulate that particular entry. Any suggestions?
Thanks!