Hello,
I have an application developed in ASP with Access as back end. The code starts as follows
It works fine in the system (windows 7) where it was developed. When I installed the same in the server (Windows Server 2008), the login html page is displayed. After giving the password, the following error is displayed:
"500 internal server error - There is a problem with the resource you are looking for"
Can anybody help me in resolving this issue.
Thanks in advance
Matsam
I have an application developed in ASP with Access as back end. The code starts as follows
Code:
<%@ Language=VBScript %>
<%
set cn=nothing
set rs=nothing
set rsUser=nothing
set rsVisit=nothing
set cn=server.createobject("ADODB.connection")
set rs=server.createobject("ADODB.recordset")
set rsUser=server.createobject("ADODB.recordset")
'if cn.state=adstateopen then cn.close
Connectstr = "DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\inetpub\wwwroot\payment\empdata.accdb;UID=;PWD="
cn.open connectstr
Response.Write Request("connectstr")
dim loginname, pwd
userid = trim(Request.Form.Item("txtLogin"))
pwd = trim(Request.Form.Item("txtPwd"))
Response.Write Request("userid")
if Request("userid") <> "" then
empcode = Request("userid")
end if
if userid <> "" then
sqlUser = "Select Password from employee where empcode = " & userid
rsUser.Open sqlUser, cn, adOpenStatic
end if
'Response.Write Request("FName")
'Response.Write (userid)
if Request("userid") = "" then
if not rsUser.EOF then
if pwd <> trim(rsUser(0)) then
Response.Redirect("default.htm")
request("txtLogin").setfocus
end if
else
Response.Redirect("Invalid.htm")
end if
else
if trim(Request.Form.Item("txtPwdOld")) <> pwd then
Response.Redirect("Invalid.htm")
end if
end if
"500 internal server error - There is a problem with the resource you are looking for"
Can anybody help me in resolving this issue.
Thanks in advance
Matsam