timeout expired

[skdesh]

while updating MS_SQL query from VB its giving message like this "Timeout Expired"

[ansumansahu]

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

[skdesh]

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

[Shubhadapp]

how to check the default timeout visual basic

[skdesh]

Loading Java Applet Failed Pl Help Me

[QVeen72]

Hi,

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

AConn.ConnectionTimeout = 200
 

If executing query on Command Object then change :
.CommandTimeout


REgards
Veena