Forum Discussion
markbain
15 years agoOccasional Contributor
Given your example I have the following code:
SProc = ADO.CreateADOStoredProc();
SProc.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CEA_NEIC;Data Source=<IP Address>";
SProc.ProcedureName = "CEA_NEIC.dbo.P_update_RPT_PI_Profile_Summary_Data_job";
SProc.ExecProc();
Log.Message("Result: " + SProc.Parameters.Items(1).Value);
and the test fails with a "JScript Runtime Error" and the following:
Query timeout expired
Unit: "Create_New_PI" Line: 25 Column: 3.
where line: 25 Column: 3 is the "SProc.ExecProc()'" line above.
Any help here?
Do I have to increase the timeout value for queries or something?
The actual Stored Procedure runs about 2min
Related Content
- 12 years agotpoirier
- 12 years agodenioflavio
- 10 years agochicks