HELP! ASP Error '80040e14' ???

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. In fact, IT
WORKS on my testing server, but not on the remote server... Are there some
code permissions or something I may need to set?

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

ODD!!! The code seems to work the first time around, but when I close my
browser and then reopen and try again, the error occurs. Maybe it has
something to do with the database being open or something. I can't really
tell. But it does work the first time...
Jordan

"Jordan Marton" <JMarton (AT) HAHAmarketaxess (DOT) com> wrote

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. In fact,
IT
WORKS on my testing server, but not on the remote server... Are there some
code permissions or something I may need to set?

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