DSN Properties

[Eugenious]

In VB6 code, I want to return the name of the server or the IP address that my DSN is currently pointed to. It's a SQL Server DSN and I'm running windows 2000 if that helps. Any ideas at all would be helpful. Thnaks in advance!!!!

GENE

[Si_the_geek]

It's stored in the registry under:

HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ {DSN name}

or:
HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\ {DSN name}

there's lots of examples on this site for using the registry if you dont already know how