I’m trying to connect to a lotus notes database on an ASP page. I’ve installed the Lotus Notes SQL driver and set up a system DSN on a win2k3 server, pointing to the relevant .NSF database. This connection is valid (i can open it using microsoft access).
However the when i try to open the connection on my page using the following code:
strDSN = “DSN=Lotus_SQL_DSN;UID=CrossbowUser;PWD=paul”
objConn.Open strDSN
I get the following error message:
Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’
[Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_DBC failed