Hi In SQL Reports (when the time for query results exceeds 1 min. or more), I've got the message 'SQL: Select .... ' and not the query results. If I execute the query on other tool its works fine. I use the string 'Connect TimeOut=300' in the Connection string but it not works. How can I configure Report Portal for that querys?
Modify sql\i_query.asp CreateTable() function to call this function:
Function GetRecordset(sSQL,sConnectionString) Dim cmd Set cmd = Server.CreateObject("ADODB.Command") cmd.ActiveConnection = sConnectionString cmd.CommandText = sSQL cmd.CommandTimeout = 60*60 Server.ScriptTimeout = 60*60 Set GetRecordset = cmd.Execute() End Function
Change the line below to call the function 'rs.Open sSql, sReportConnection set rs = GetRecordset(sSql, sReportConnection)
Report Portal
Time Out in SQL Reports
Posted - 10/07/2004 : 10:31:23
