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.

  • Well I think one problem is that I need to have notes installed which I did not realize. Why can't the driver just work on it's own? – Kenneth Lynch Oct 18 '11 at 14:25
  • Not really a solution, but if you need to do a lot of Notes to SQL data transfer (vica versa) you might prefer to buy a package called Notrix. It requires a Domino server to host the applicationm, but doesn't require a Notes client on the SQL Server. You also need the latest SQL Server ODBC driver as SQL Server 2000's driver memory leaks with the latest version of Notrix. It beats LEI and NotesSQL hands down for functionality. – booyaa Nov 29 '11 at 9:57

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.

source: Keysolutions

  • I tried opening the odbcad32.exe in the SysWOW directory but I will try modifying the the registry and see if that works. Thanks – Kenneth Lynch Oct 18 '11 at 13:08
  • also you more then likely will need to run the syswow odbcad32.exe as admin – tony roth Oct 18 '11 at 19:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.