reading odbc entries in vbscript

[Programmer1974]

Greetings!

I have a program that I'm trying to write where I need to allow the user to select an ODBC entry that is already defined. For instance, if I go to DataSources(ODBC) and I see "ODBC1", "ODBC2", and "ODBC3" as system DSNs, I want to show a list of these three options. How can this be easily done?

I know there is the INI file: ODBC.ini that I could read, but from looking at other posts, the DSN entries can also be accessed from the registry. All the examples that I've found show adding entries, not reading. So, could someone please provide some examples of reading the DSN entries from the registry?

Thank you much!

 

[PHV]

Do a keyword search in this forum for stdregprov

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244