I am brand new to Lotus Notes so please forgive and newbieisms.
I have been given an nsf file from a client and asked to import it into SQL Server 2005. I have installed Lotus Notes Client 8.5 and I can open their application. I have installed NotesSQL 8.0 and used the NotesSQL Authentication List Manager to add a user id file to the user list. I have added the path where the notes dlls are held to the PATH environment variable (can’t remember why at this point). In user security in the Notes application, I have given my account a password and I have set up a system DSN using the Lotus NotesSQL Driver, the nsf file I was given and the username and password that appears in Notes (I have selected local for the Domino server).
There is no “test connection” option in this screen but I don’t get any error either.
Have I missed anything out? The reason I ask is that when I create a linked server in SQL 2005 I get an error saying the “test connection to the linked server failed” but I can’t figure out why.
Any help would be greatly appreciated.
Subject: ODBC Log
Update:
I turned on tracing in the ODBC Administrator and can see the following error when I try to connect in visual studio:
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed (0)
DIAG [01000] [Microsoft][ODBC Driver Manager] The driver doesn’t support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). (0)
Any ideas what this means?
Subject: logs
I ran an ODBC trace which gave me
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed (0)
DIAG [01000] [Microsoft][ODBC Driver Manager] The driver doesn’t support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). (0)
I’m not sure about this but in the event log I have the following error
Event Type: Error
Event Source: NotesSQL
Event Category: None
Event ID: 1005
Date: 12/03/2009
Time: 15:18:28
User: N/A
Computer: MHNW0014
Description:
Could not load NSQLE32.EXE. This file must exist in the same directory NSQL32.DLL and NSQLV32.DLL is in. It is possible NSQLE32.EXE could not be loaded because NotesSQL couldn’t locate a valid Notes/Domino installation (couldn’t find NNOTES.DLL) – this may be because user (mccashinb) does not have the correct rights to the Notes/Domino directory. It could also be because NotesSQL can not find your Notes/Domino installation in the Registry. NotesSQL looks for the NNOTES.DLL file by looking in the path pointed to by the following Registry entries – HKEY_LOCAL_MACHINE\Software\Lotus\Notes{version}\Path : HKEY_LOCAL_MACHINE\Software\Lotus\Domino{version}\Path. If neither of these registry entries exist or they point to an invalid version of Notes/Domino NotesSQL will not work. To resolve – please re-install Notes/Domino.
NSQLE32.EXE exists in c:\NotesSQL as do NSQL32.DLL and NSQLV32.DLL
mccashinb is in the administrators group on this machine
the first reg key mentioned contains the correct path to the directory with the nnotes.dll
the second key does not exist – domino is not installed on this pc
I only installed notes yesterday so I don’t think there could be anything missing but I’m at a bit of a loss at this stage.