how to get dsn system information (ip address or name) with vbcode

[xquestions]

Is it possible to get the dsn system information from an odbc source using
vbcode. Example: I have an ODBC connection to a database under by system dsn
tab, and would like to get that using vbcode.

Thanks in advance.

 

[Douglas J. Steele]

ODBC entries are in the registry. System DSNs are under HKLM\SOFTWARE\ODBC,
while User DSNs are under HKCU\SOFTWARE\ODBC.

Do a little speleunking to see what you can get.

 

[DavidAtCaspian]

If you already have a link in you database, you can get a lot of information
about it from the MSysObjects table.

Set access (temporarily) to view System objects, open the MSysObjects table,
and browse arounf it for a few minutes, and it should become very clear and
extremely easy to find what you want.

MSysObjects can be opened and queried like any oher table from VB.