Issues with ASP getrows and Oracle

mussitsch · December 23rd, 2008, 01:34 PM

Any one experience a problem using getrows to retrieve data from an Oracle stored procedure versus getrows to retrieve from SQL Server. SQL Server was working fine. Can it be done.

Thanks.
Melissa Mussitsch
[email protected]

Old Pedant · December 23rd, 2008, 06:40 PM

Not aware of any issues, but you may need to make sure that you are using a client-side cursor:

Code:

Set RS = Server.CreateObject("ADODB.Recordset")
RS.CursorLocation = 3 ' adUseClient
RS.Open SQL, conn 
...

Does it work okay if you do *NOT* use GetRows()??