|
|
|
|
|
| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Timeout with Oracle query |
|
From: |
Si |
|
Date: |
8/22/2000 5:30:52 AM |
|
IP: |
194.205.246.147 |
Hi,
Im getting a operation timeout on my asp page when I run a large query (pass through) to an Oracle database.
my connection works fine:
Set objRs = Server.CreateObject("ADODB.Recordset")
objRs.Open sql, objconn, adOpenForwardOnly, adLockReadOnly, adCmdText
I also have increased all the timeouts on the server to max but I get a message back after say 5-7 mins and sometimes it renders the server hung - The requested resource is in use
The query will run in about 10-15mins via Access...
any body can help would be appreciated.
Si. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
