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.