469,166 Members | 2,172 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,166 developers. It's quick & easy.

timeout expired

9
while updating MS_SQL query from VB its giving message like this "Timeout Expired"
Jun 12 '07 #1
5 1756
ansumansahu
149 100+
while updating MS_SQL query from VB its giving message like this "Timeout Expired"
Hi ,

Check whats the default timeout that is set. Then increase it accordingly. Also are you able to execute the query on the query analyzer sucessfully or does it throw a time out exception.

good luck
-ansuman sahu
Jun 12 '07 #2
skdesh
9
Hi ,

Check whats the default timeout that is set. Then increase it accordingly. Also are you able to execute the query on the query analyzer sucessfully or does it throw a time out exception.

good luck
-ansuman sahu
thanks for repl
From Query Analyzer its work but from Updating thru VB its giving this error
Jun 12 '07 #3
how to check the default timeout visual basic
Jul 4 '07 #4
skdesh
9
Loading Java Applet Failed Pl Help Me
Sep 11 '07 #5
QVeen72
1,445 Expert 1GB
Hi,

U must have connected to the database using ADO Objects. Change the ADO Connection object's ConnectionTimeout to some higher value:

Expand|Select|Wrap|Line Numbers
  1. AConn.ConnectionTimeout = 200
  2.  
If executing query on Command Object then change :
.CommandTimeout


REgards
Veena
Sep 11 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Silvia | last post: by
5 posts views Thread by Jason | last post: by
3 posts views Thread by Nils Magnus Englund | last post: by
3 posts views Thread by rn5a | last post: by
1 post views Thread by Scorpion657 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.