vikas_pant_se
10 years agoNew Contributor
ODBC timeout issue
While executing the following code I am getting timeout issue.
AConnection = ADO.CreateConnection();
AConnection.Open ("Driver={SQL Server};" + ProjectSuite.Variables.Server + ProjectSuite.Variables.Database + ProjectSuite.Variables.Login);
Cmd = ADO.CreateCommand();
Log.Message("Create command for the db");
Cmd.ActiveConnection = AConnection;
Cmd.CommandType = adCmdText;
Cmd.CommandText = NotPollingQuery;
recSet = Cmd.Execute();
On the ecexution for this command i get timeout issue recSet = Cmd.Execute();
AConnection = ADO.CreateConnection();
AConnection.Open ("Driver={SQL Server};" + ProjectSuite.Variables.Server + ProjectSuite.Variables.Database + ProjectSuite.Variables.Login);
Cmd = ADO.CreateCommand();
Log.Message("Create command for the db");
Cmd.ActiveConnection = AConnection;
Cmd.CommandType = adCmdText;
Cmd.CommandText = NotPollingQuery;
recSet = Cmd.Execute();
On the ecexution for this command i get timeout issue recSet = Cmd.Execute();