Lotus NotesSQL on Win7 64bit - Error 126 creating DSN (path changes already tried)

StuckInTheMud
StuckInTheMud used Ask the Experts™
on
I'm trying to get NotesSQL v8 running on Windows 7 64bit.

Installed the driver, appears correctly under the 32bit ODBC configuration.

Try to create a DSN (of any type) and I get the NotesSQL Driver could not be loaded due to error 126 (c:\NotesSQL\nsqlc32.dll not found).

Googled the problem, lot of people with the problem and many references to making sure PATH includes the relevant folders.

So, PATH has been correctly set with the following, to find the dll's and notes.ini
C:\NotesSQL
C:\Users\j_andrews\AppData\Local\Lotus\Notes\Data


Anyone any clues as to why I'm still getting the 126 error?



Jim
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You have to use a REAL 32bit ODBC configuration client!

I fight an hour on this until I realize I need to use:
C:\Windows\SysWOW64\odbcad32.exe

NB I assert that since you google around you follow correctly the install since you already solved the notes.ini and notesSql Path problem.

Found another suggestion via Google, that v8 of NotesSQL doesn't work properly on Windows 7.

Tried the latest v8.51 (which isn't obvious in the downloads) and all is working fine.

Author

Commented:
Answered the question with further research.
I used a user DSN and it worked on that version.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial