Recently our company upgraded from Win Server 2000 to 2003. We have a web timecard application on our Intranet site which would prompt for a user/pass and once entered open the user's specific timecard. Once the upgrade occured, everything on the new Intranet site works fine except for the timecard. Here is the error that we now get instead of a login prompt:
Active Server Pages error 'ASP 0113'
Script timed out
/timesheet/default.asp
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
I read about how to "Trap Error 'ASP 0113' Script Timed Out" by using the '"TRANSACTION=required" argument' and now get this message:
Microsoft OLE DB Provider for ODBC Drivers error '8004d00a'
[Microsoft][ODBC SQL Server Driver]Distributed transaction error
/timesheet/default.asp, line 20
line 20 is a connection to a database (code as follows):
Set EdenConn = Server.CreateObject("ADODB.Connection")
ProvStr = "driver=SQL Server;Server=***.***.***.*;uid=user;pwd=******;database=Gold"
EdenConn.Open ProvStr
Set EdenRS = Server.CreateObject("ADODB.Recordset")
Any help would be much appreciated.
Active Server Pages error 'ASP 0113'
Script timed out
/timesheet/default.asp
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
I read about how to "Trap Error 'ASP 0113' Script Timed Out" by using the '"TRANSACTION=required" argument' and now get this message:
Microsoft OLE DB Provider for ODBC Drivers error '8004d00a'
[Microsoft][ODBC SQL Server Driver]Distributed transaction error
/timesheet/default.asp, line 20
line 20 is a connection to a database (code as follows):
Set EdenConn = Server.CreateObject("ADODB.Connection")
ProvStr = "driver=SQL Server;Server=***.***.***.*;uid=user;pwd=******;database=Gold"
EdenConn.Open ProvStr
Set EdenRS = Server.CreateObject("ADODB.Recordset")
Any help would be much appreciated.
