Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
    
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

1 Answer 1

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

share|improve this answer
    
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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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