I have been thinking of using VBscript to automate the set up of the ODBC
DSN entries. There are some discussions on the Internet that I can find.
Unfortunately, none of them gives me any hints on how I can store the
username (such as sa) and password for the connection.
I know I can use VBscript to modify the registry or simply importing the
..REG files which I exported from a manually created DSN entry. Here is the
key to be modified:
HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources\
Although I can manually create a new DSN and stored the password (through
Control Panel or by running ODBCAD32), I can't find the password in the
registy. Anyone has a good suggestion?
Joe
>> Stay informed about: Automate ODBC DSN Setup