2. ASPRunnerPro General questions
  3. ODBC Timeout
This topic is locked

ODBC Timeout

 		4/12/2004 10:30:08
ASPRunnerPro General questions
D
 dan_vt author

Good morning from the chilly mountains of central Vermont.
I love ASP Runner. It is my secret weapon for meeting end user needs really fast. All my programmer friends are impressed. I am not just saying this.
Unfortunately, however, I have encountered an ODBC timeout error. Here is a link to a screenshot of the error message (Screenshot of error).
I assume there is an easy way to extend the time allowed by ODBC to complete a query.
I can make the query faster, but what I really want to do at this point is to find out how to give ODBC more time to complete its query.
As always, any information helping to resolve this problem will be appreciated immensely.
Best regards,

dan_vt
Sergey Kornilov admin 4/12/2004

Dan,
try to make the following changes in ..._list.asp file (in bold).

function setupRs(strConnection,strSQL,nPageSize)

Err.Clear
Set setupRs = server.CreateObject ("ADODB.Recordset")

set dbConnection = server.CreateObject ("ADODB.Connection")

dbConnection.ConnectionString = strConnection
dbConnection.ConnectionTimeout = 120

dbConnection.CommandTimeout = 120
dbConnection.Open

Call ReportError


Let me know if it fixes the problem.
D
 		dan_vt author 4/12/2004

Indeed Sergey, that fixed the problem.
Thanks much.
Sergey, sorry if this is too personal, but with your name, I am guessing you are Russian? Was ASPRunner developed in Russia? Just curious.
I really like this product a lot.
-Dan
Sergey Kornilov admin 4/12/2004

Dan,
you are right, I'm from Russia originally.
ASPRunner is being developed in Nothern Virginia, USA.