| T O P I C R E V I E W |
| Gustavo |
Posted - 10/07/2004 : 10:31:23
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?
Thanks
Gustavo - Argentina |
| 1 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 10/08/2004 : 07:17:31
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
