>> Open ODBC.ini

J

Jonathan

Hi using Access 2003. Is it possible to programmatically open the odbc.ini
file to get the server name for a dsn?

Any ideas or suggestions appreciated :)

Many thanks,
Jonathan
 
T

Tom van Stiphout

On Thu, 21 Aug 2008 20:26:01 -0700, Jonathan

It's a standard text file. VBA offers functions to read text files
(Open, Line Input, ...) as well as for parsing text (Split, InStr,
....)

-Tom.
Microsoft Access MVP
 
J

Jonathan

Hi, thanks for your response. Actually I now see that the odbc.ini file only
contains the dsn name and driver. To retrieve the server name I will have to
interogate the HKEY_LOCAL_MACHINE registry setting.

Any ideas to do this?

Many thanks
Jonathan
 
Top