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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

xquestions - 08 May 2008 02:22 GMT

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.

Reply to this Message

Douglas J. Steele - 08 May 2008 22:11 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

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

Reply to this Message

DavidAtCaspian - 10 May 2008 13:01 GMT

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.

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

Reply to this Message

Rate this thread: