Hi all,

My program access SQL Server 2000 with ADO 2.8.
Some of stored procedures my program invoke takes more than 30 minutes
because it works a lot of record update. (Of course, it is already optimized
but the amount is still large.)
The problem is that ADO returns timeout error during it waits for returning
from that stored procedure, even if it works with no problem at all.
I thought it should be solved by setting time out values for both ADO and
stored procedure, but I cannot find any statements that reside in stored
procedure.
Of course, I tried setting time out value into ADO object, but it didn't
solve that problem.

Please reply any resolutions. Thanks in advance.

Regards,
Hyun-jik Bae

See if the following help:
http://vyaskn.tripod.com/sql_odbc_timeout_expired.htm
http://vyaskn.tripod.com/watch_your_timeouts.htm
My program access SQL Server 2000 with ADO 2.8.
Some of stored procedures my program invoke takes more than 30 minutes
because it works a lot of record update. (Of course, it is already optimized
but the amount is still large.)
The problem is that ADO returns timeout error during it waits for returning
from that stored procedure, even if it works with no problem at all.
I thought it should be solved by setting time out values for both ADO and
stored procedure, but I cannot find any statements that reside in stored
procedure.
Of course, I tried setting time out value into ADO object, but it didn't
solve that problem.

Please reply any resolutions. Thanks in advance.

Regards,
Hyun-jik Bae

Error converting data type nvarchar to int.
move records from table1 to table2 if does not exist in table3
Query Help
FIFO report
Performance Issues using Aggregate MAX function within a temp table