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

  • Thread starter Thread starter xquestions
  • Start date Start date
X

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.
 
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.
 
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.
 
Back
Top