Data Source Name Not Found Error w/ DCR or LSX SQL Connection

Mindwatering Incorporated

Author: Tripp W Black

Created: 12/18/2009 at 09:27 AM


Notes Developer Tips
LSX (LotusScript Extensions/Connectors)

Registered a System DSN for remote SQL Connection (oledb). However, error message indicates that no such setup has been done.
Server is Windows 2003 64bit.

Error: Unable to locate OLE DB Provider. Connector 'oledb'.

The Windows 2003 ODBC drivers are 64 bit in the Admin applet control panel. Microsoft has hidden the 32 bit program.
It's at: c:\windows\syswow64\odbcad32.exe

previous page