Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.
snr

snr

Programmer
Oct 8, 2001
78
0
0
US
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
 
Status
Not open for further replies.

Similar threads

marty1944
  • Locked
  • Question
error code 380 when trying to run the visual basic v6 deployment wizard
Replies
1
Views
160
marty1944
marty1944
2009luca
difficult to crteate a query very complicated 1
Replies
9
Views
615
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
CHECK color of shape 2
Replies
5
Views
106
strongm
strongm
Niki_S
  • Locked
  • Question
Error in Excel/VB6 function: "Constant expression required"
2
Replies
31
Views
307
strongm
strongm
2009luca
  • Locked
  • Question
population of italy live/real time
Replies
11
Views
133
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top