Timeout Expired error thrown in QTP
Iam executing few queries in the SQL server through QTP for automating a process. When executing the 5th query, QTP throws an popup saying "Timeout Expired".
When the same query is executed in the SQL server directly, it gets executed fast.
Could anyone please help, how to solve this issue.
Re: Timeout Expired error thrown in QTP
May be the below code is helpful for you:
Set oraComm = CreateObject ("ADODB.Command")
oraComm.ActiveConnection = connDB
oraComm.CommandText = strQuery
oraComm.CommandTimeout = 0