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 ConnectionTimeo ut to some higher value:

[code=vb]
AConn.Connectio nTimeout = 200
[/code]

If executing query on Command Object then change :
.CommandTimeout


REgards
Veena