Session onend problem

[Inhumanoid]

I get a runtime error when I open a adodb connection inside the session_onend in the global.asa. After that I need to restart IIS in order to get db communication working again... I don't think I do anything fancy:

Dim strSQL, objRS, objConn


strSQL = "SELECT CursusID, CursistID, Begin WHERE CursusID =" & Session("CourseID") & " AND CursistID = " & Session("CursistID") & ";"

Set objConn = server.CreateObject("ADODB.Connection")
Set objRS = server.CreateObject("ADODB.recordset")

objConn.Open ("PROVIDER=MSDASQL; DRIVER={Microsoft Access Driver (*.mdb)}; UID=admin;PWD=opensesame; DBQ=D:\DataStores\cont.mdb")



I get the internal error when I call objConn.Open

[monte96]

You can't use both a provider AND a driver:

objConn.Open ("PROVIDER=MSDASQL; DRIVER={Microsoft Access Driver (*.mdb)}; UID=admin;PWD=opensesame; DBQ=D:\DataStores\cont.mdb")

Providers use OLEDB and Drivers use ODBC. Use the OLEDB provider for Jet...