I'm restoring an old asp application on a windows server 2003, this application use an Access file to its operation.
I could setup asp again on the server but when we execute the pages, the server said that the page can not be showed, a http error 500 appears.
The default.asp page is displaying without problems, that is a login user page, then we put the username and password that is sent to another page called Authentication.asp then the error 500 occurs. At this point I don't know if I miss a configuration or we need to setup another application or what.
I check the code, and probably the page crash in this place:
lNextASP = "Default.asp"
lUserName = Request("tNombre")
lPassword = Request("tPwd")
Set gDataBase = Server.CreateObject("ADODB.Connection")
Set gDataSet = Server.CreateObject("ADODB.Recordset")
gSql = "SELECT U.IdUsuario, U.Clave, U.Tipo, HM.IdHospital FROM tUsuarios AS U INNER JOIN tHospMed AS HM "
gSql = gSql & "ON U.IdUsuario = HM.IdUsuario "
gSql = gSql & "WHERE U.Cancel = 0 AND U.Clave = '" & lUserName & "' AND U.Pwd = '" & lPassword & "'"
gDataSet.Open gSql, gDataBase
I know that is an old application based on asp classic and VB language, but now I don't have ideas on how to setup this old fashion asp application.
Additionally I tried to check what is the error on the server but I notice that the windows server 2003 doesn't have a log error for the web server. Is it possible to setup a log error file to the web server?
Somebody can help me?. Thank you