I'm trying to install the NotesSQL Driver on a Server 2008 machine in order to run Reports in Report Server against a Lotus/Domino database but I can't get it to work at all. I downloaded the latest version 8.5 but it doesn't even show up in the ODBC window.
The NotesSQL driver is a 32-bit ODBC driver, so you have to register it as such
ODBC on running on a 64-bit-based operating system has two sets of system DSN settings stored in the Windows Registry. 32-bit client applications use the 32-bit settings. 64-bit applications use the 64-bit settings.
If you run "%SystemRoot%\SysWOW64\odbcad32.exe", you modify the 32-bit settings. If you run "%SystemRoot%\system32\odbcad32.exe", you modify the 64-bit settings (this is the one run from the Control Panel --> Administrative Tools --> Data Sources --> ODBC).
You must register the System DSN for the ODBC32 drivers with SysWOW64\odbcad32.exe.