How to get the names of System DSNs available on the machine

[Nauman]

How can i use the GetAllSettings Function in VB6 to get the names of System
DSNs available on my machine. The system DSNs are available at the following
location in the registry.

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

The GetAllSettings Function uses the default path as

HKEY_LOCAL_MACHINE\SOFTWARE\VB and VBA Program Settings

What if i want to read All Settings from "ODBC\ODBC.INI" instead of "VB and
VBA Program Settings"

Any help wud be greatly appreciated.

Regards

Nauman

 

[Tammy B.]

That's a good question. I'd like to know myself.
They may reside in a folder, and you could use the file system thingy to
query the folder

 

[Douglas J. Steele]

You can't use GetAllSettings: as you note, it's only capable of reading one
specific part of the registry.

To read any part of the registry, check the sample code in
http://www.mvps.org/access/api/api0015.htm at "The Access Web".

 

[Tony Toews]

How can i use the GetAllSettings Function in VB6 to get the names of System
DSNs available on my machine. The system DSNs are available at the following
location in the registry.

If you can I much prefer DSN-Less connections as it is one less thing
for someone to have to configure and one less thing for the users to
screw up.

Using DSN-Less Connections
http://members.rogers.com/douglas.j.steele/DSNLessLinks.html

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm