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

 

Category:
Notes Developer Tips
LSX (LotusScript Extensions/Connectors)

Issue:
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'.

Resolution:
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