|
Subject:
|
Microsoft JET Database Engine (0x80040E14)
|
|
Posted By:
|
HaverkPJ
|
Post Date:
|
11/15/2004 11:40:41 PM
|
Can anyone help with the following error?
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
---------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
Microsoft JET Database Engine (0x80040E14)
Internal OLE Automation error
/depts/pharmacy/risklink/login_post.asp, line 56
The Access 2000 query SQL is as follows:
PARAMETERS [USERNAME] Text ( 255 ), [PWORD] Text ( 255 );
SELECT *
FROM Staff_Members
WHERE (((Staff_Members.UserName)=[USERNAME]) AND ((Staff_Members.Pwd)=[PWORD]) AND ((Staff_Members.Status)<>1));
Code from the page is as follows:
Dim cn
Dim cmd
Dim objParam
Dim objParam_pwd
Dim rsAuthenticated
'Open connection
Set Cn = Server.CreateObject("adodb.connection")
cn.provider = ps & " Data Source=" & Server.MapPath(ds)
cn.Open
'Create command to view the current topics
Set cmd = Server.CreateObject("adodb.command")
Set cmd.ActiveConnection = cn
cmd.CommandText = "qryStaffMember_Authenticate"
cmd.CommandType = adCmdStoredProc
'Create the parameters
Set objParam = cmd.CreateParameter
objParam.name = "USERNAME"
objParam.type = adVarChar
objParam.direction = adParamInput
objParam.size = 10
objParam.value = Cstr(Request.Form("txtUserName"))
'Append the parameter to the command object
cmd.Parameters.append objParam
Set objParam_pwd = cmd.CreateParameter
objParam_pwd.name = "PWORD"
objParam_pwd.type = adVarChar
objParam_pwd.direction = adParamInput
objParam_pwd.size = 10
objParam_pwd.value = CStr(Request.Form("txtPwd"))
'Append the parameter to the command object
cmd.Parameters.append objParam_pwd
'Create the recordset
Set rsAuthenticated= Server.CreateObject("adodb.recordset")
rsAuthenticated.CursorType = adOpenForwardOnly
rsAuthenticated.LockType = adLockReadOnly
Set rsAuthenticated = cmd.Execute() <-- line 56 -
Runs on Windows 2000. Does not run on Win XP SP2.
Any help would be greatly appreciated!
|
|
Reply By:
|
happygv
|
Reply Date:
|
11/16/2004 2:44:26 AM
|
Check out this sample code for reference and see what you are missing.
Using stored proc in ASP with command object
Hope that helps.
Cheers!
_________________________
- Vijay G
Strive for Perfection
|
|
Reply By:
|
HaverkPJ
|
Reply Date:
|
11/16/2004 10:25:30 PM
|
Nope. Checked the code versus the example. Even changed the multi-line properties to single line as in the example. Same error.
Thought maybe it is a provide error. Switched to *.mdb driver directly and via a system DSN. Both report an automation error on the cmd.execute line.
Any other ideas? I'm just worried about when we switch our corporate web server from Win2000 to WinXP.
Thanks.
|
