>> Open ODBC.ini

  • Thread starter Thread starter Jonathan
  • Start date Start date
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
 
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
 
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
 
Back
Top