View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default VBA to check for existence of a DSN

GPO,
One way is read the registry. e.g enumerate the values at :
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI

See http://www.vb-helper.com/howto_create_dsn.html for examle.

NickHK

"GPO" wrote in message
...
XL 2000
Can anyone point me to a bit of VBA that checks a user's PC for the
existence of a DSN?

Cheers

GPO