Thanks to QV - Community Post for details : http://community.qlik.com/thread/12541
Very useful for LOTUS Note Connection
To use Notes data through ODBC, you must have:
- Notes SQL, the Lotus Notes ODBC driver
- An ODBC Driver Manager version 3.5 or later
- One of the following:
- Microsoft Windows 2000, or XP
- Microsoft Windows 2003 Server Standard Edition or Enterprise Edition
- Microsoft Windows Vista
- Microsoft Windows 2008
- Microsoft Windows 7
- One of the following:
- Lotus Notes Client release 6.0 or later
- Lotus Domino release 6.0 or later
- Lotus Notes Designer release 6.0 or later
- Lotus Domino Off-Line Services release 1.01 or later
OK, and then few steps: (this works in windows 7 x64)
1) Install NotesSQL - driver to C:\NotesSQL
2) add your Lotus Notes directory to the %PATH% Variable
3) Reboot
4) run c:\windows\syswow64\odbccad.exe
5) You should now find the NotesSql ODBC driver to create the ODBC connection normally
