Cannot connect to Notes DB with DSN and .Net

I know that this has been of posted before but I have tried everything and cannot get the error to go anyway.

I have a Windows 2003 Server with SP2 installed on it, ASP.net 2.0, IIS 6.0. I have installed Notes 6.5.4 Client and NotesSQL 3.02. I have configured and System DSN, before that I made sure the I configured the NotesSQL Authentication List Manager.

Now is have been looking at the Event Viewer and I have been getting

Event Id: 1005

Source: NotesSQL

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 (whalens) 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.

Now I have uninstalled everything and reinstalled it from scrtach and got the error message again. For some reason I am now getting this error in the Event logs

Event Id: 1006

Source: NotesSQL

Description: Cannot locate the ID file Nothing listed in the KeyFilename entry in the NOTES.INI (located at C:\Program Files\lotus\notes\notes.ini). Please verify the ID listed in KeyFilename is correct before continuing.

These are coming both from the Appication Log. I checked the System log and seen this event:

Event Id: 7036

Source: Service Control Manager

Description: The Lotus Notes Single Logon service entered the stopped state.

Event Id: 3019

Source: MRxSmb

Description: The redirector failed to determine the connection type.

Just adding those in case they mean something.

Now just so you know the code that I am using here it is:

-----------------------source code--------------------------

<%@ Page Language=“VB” %>

<%@ Import Namespace = “System.Data.Odbc” %>

Untitled Page

----------------------end source code-------------------------

If anyone can help me out that would be greatly appriciated.

Shannon

Subject: Cannot connect to Notes DB with DSN and .Net

Not sure if this helps as well but I get this error on the aspx page as well…

ERROR [IM005] [Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_DBC failed

ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn’t support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).