Problem of "timeout Expired" when trying to execute a stored procedure

[snr]

Hi,
I am trying to execute a stored procedure through VB application. If I run the stored procedure through Query Analyser , it takes around 1 min to complete.
As I was getting this error, I tried writing
con.ConnectionTimeout = 0
con.CommandTimeout = 0
But still its giving the same error.
Please help.

Thanks

 

[Foada]

I don't know what you are using to connect but if you are using ADO 2.5 or earlier you may want to look at Article Q175264 on MSDN If you choose to battle wits with the witless be prepared to lose.

 

[TomKane]

Try using SQL's query profiler or check the active processes in enterprise manager - it may give you some clue...