Hopefully someone can assist me on this. I am trying to use the Lotus NotesSQL 3.0.2g for Windows in an Active Server Page. I downloaded the sample kit which has this type of sample, but I keep getting the following error:
Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’
[Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_DBC failed
/nsqlsample/ListAllUsrs.asp, line 25
The line it is referring to is:
22 ’ Create ADO Connection Component to connect with sample database
23 Set oConn = Server.CreateObject(“ADODB.Connection”)
24 oConn.ConnectionString = “DSN=NotesSQL_SampleDB”
25 oConn.Open
I have tried all of Lotus’ suggestions that were listed here and I still can’t get it to work. http://www-12.lotus.com/ldd/doc/notessql/3.0.2f/notessql.nsf/66208c256b4136a2852563c000646f8c/7005c9ff90581a4385256dd7004d81f5?OpenDocument
The server I am attempting to run this on is a Windows 2000 DC, W SP4 fully updated. The Notes Client is 6.5.1.
Does anyone have a suggestion or recommendation?
Thank you
Brian