This topic is locked

Error number -2147217871

12/1/2004 8:17:20 PM
ASPRunnerPro General questions
T
tsd author

Hello,

I'm using Windows XP SP2 with ASPRunner3.1 in trial to put together some pages for a UPS tracking database. I have pages that work with this database now that are working off the same machine. What is the best fix or fix for the following error. Any help would be greatly appreciated.
Matthew
Error number -2147217871

Error description [Microsoft][ODBC SQL Server Driver]Timeout expired
This is a SQL 2000 SP3 database table and I have the lastest MDAC 2.8 installed. I found an article that speaks about using the global.asa file and I have tried but that did not work. This is what I added to the file.

<script LANGUAGE=VBScript RUNAT=Server>

Sub Session_OnStart

Session("ConnectionString") =

"DSN=SQLSysDSN;UID=sa;PWD=*****@;DATABASE=sidsql;APP=ASP script"

Session("ConnectionTimeout") = 15

Session("CommandTimeout") = 30

End Sub

Sergey Kornilov admin 12/5/2004

This error probably means SQL query returns a lot of data causing

timeout problem.
Try to use "No records on the first page" option in ASPRunnerPro when

you build ASP code for this table.