Restoring an old web asp application on windows server 2003
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") gDataBase.Open Application("dbOpenLine") 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
Visual Basic.NETWindows Server 2003Microsoft Access
I guess that this part of my problem, but I don't know how to check what this function return, because I don't know how to check this, there is not any error log to check, and I don't have full experience with asp.
Any suggestion to know how to check the output of this function? Even I don't understand this part of the code: Application("dbOpenLine")
1. I found out function "Application" and I didn't find any reference in the method Open
2. "dbOpenLine" doesn't seem to be and Access file, the people that give to me this application to restore, gave me a mdb file which name is not dbOpenLine.
So I'm a little lost about how to debug this part of the code.
Could you help me to figure out what can I do?
Thank you
Nasir Razzaq
Application is one of the built in ASP objects. Application("name") returns a value that was previously stored with that name so
Application("DB") = "blablabla"
and the
Application("DB") will return "blablabla"
Is this Application("dbOpenLine") being used anywhere else?
CloudHelpdeskOne
ASKER
Well, within the page, no previous reference to this object. Neither, exist any reference to an include file with this code
These are the first lines of the file.
<%Option Explicit%><%Dim lName, lUserName, lPassword, lIP, lNextASPDim gDataSet, gSql, gError, gDataBase, lDataSet, lExist lNextASP = "Default.asp" lUserName = Request("tNombre") lPassword = Request("tPwd") Set gDataBase = Server.CreateObject("ADODB.Connection") gDataBase.Open Application("dbOpenLine") 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 If gDataSet.EOF Then gError = "No account found" Else...
The error is: Data source name not found and no default driver specified
Error: 80004005
I google this error but I found suggestions to windows server NT and 2000, that I checked them to use in the server and these instruccions are not useful on windows server 2003.
Suggestions?
Nasir Razzaq
But you did create the websitedb datasource right?
Any suggestion to know how to check the output of this function? Even I don't understand this part of the code: Application("dbOpenLine")
1. I found out function "Application" and I didn't find any reference in the method Open
2. "dbOpenLine" doesn't seem to be and Access file, the people that give to me this application to restore, gave me a mdb file which name is not dbOpenLine.
So I'm a little lost about how to debug this part of the code.
Could you help me to figure out what can I do?
Thank you