I have problem with executing stored proc through VB6.0
to Sql 2000.
The stored proc takes 2 min to run from query analyzer and runs successfully, but when I run it through VB command object it gives me 'timeout expired' error.

I have tried setting .CommandTimeout = 60 * 20 or even 0, but the
call returns within 30 sec.

the .CommandTimeout = 60 * 20
The query time-out(sec) setting on the Tools > options > advanced
is set to be 0.
I sure it has something to do with sql server.
Please suggest!


ssingh

Check the connection timout.

regards
David Cameron

Hi,
I am facing the same issues,can anybody tell me is there any way i could resolve this issue
Thanks In advance

There is a property called ConnectionTimeout, the default value is 15 seconds. You might want to increase that suitably.

Hemant Gaur

I think the corect property is CommandTimeout of ADODB.Connection. I usually set this to 180 (in seconds).