[Microsoft][ODBC SQL Server Driver] TIME OUT ERROR

rtr1900 · November 12th, 2008, 08:06 AM

Hi,

I have an AS page which has some loops, and executing it, it usddenly gives me an out of time error. In spanish it is

Code:

Microsoft OLE DB Provider for ODBC Drivers error '80040e31' 

[Microsoft][ODBC SQL Server Driver]TerminÃ³ el tiempo de espera 

/listados/listado68_excel_check.asp, lÃnea 80

Line 80 has the next code

Code:

sql4="UPDATE mae_lped_ped set cant_final="&cant_final&" where cod_art="&rs2("cod_art")&" and cod_ped="&num_ped&""
rs4.open sql4,conn4

Now it would be logical to show up this error when it executes it the first time. But it passes let us say 50 times before it sows the error. so the Syntax must be good.

Anybody can help me with this one

Thx

Johny

rtr1900 · November 12th, 2008, 09:36 AM

Ok, I found the bug!

Some codes before (a 50 lines) I did an SQl syntax, but never closed it afterwards. So after some 50 secs it gave me the out of time error.....
Am I glad that everything is working fine.....

Ok, back to work :-)