ASP Error: -
07-13-2003
, 03:39 PM
Hi. A few days ago this seemed to have worked fine, and for some reason, I am getting the following error now when trying to access a page.
Here is the error...
==============
Microsoft JET Database Engine error '80040e14'
Unknown name
/INCLUDES/inc_LOGIN.asp, line 57
==============
And here is the code:
==============
If MM_rsUser("AOLIM")<>"" AND Session("AOLIM")="" AND Session("AOLIMLoginRecord")=False Then
Session("AOLIM") = MM_rsUser("AOLIM")
Dim connStr = MM_myDB_STRING
Dim con
Set con = Server.CreateObject("ADODB.Connection")
con.Open connStr
con.Execute "exec AOLIMLoginRecord " & Session("AOLIM") & ", " & Session.SessionID
con.Close
Set con = Nothing
Session("AOLIMLoginRecord")=True
End If
==============
Line 57 is the con.Execute line. AOLIMLoginRecord is a stored query in the Access database that first asks for a string (aol im name) and then a session id and searches in the table for that session id and sets its aolim name to the session("aolim"). It works if I do it through access, but not with this code. Can anyone see anything?
Also, do session id's repeat? And if so, how often?
Jordan |