MDAC 2.7 SP1 REFRESH and Microsoft ODBC for Oracle

From: Oliver McErlane <oliver_mcerlane_at_hotmail.com>
Date: 14 Sep 2004 04:59:30 -0700
Message-ID: <5e66b3ce.0409140359.696be468@posting.google.com>

The below code was written to append data to to a external Oracle database.
The server OS is Windows 2000.
I am using the Microsoft ODBC for Oracle When SQL Service Pack 3a was installed on the server, MDAC was upgraded from 2.6 to 2.7 SP1 REFRESH.
Now I get the error message...

   Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

   ODBC driver does not support the requested properties.  

at the line where rsf.open, see code below. I am not sure if this upgrade is causing the problem.  

Please Help!
Ollie.

<%

                        Set cmdf =

Server.CreateObject("ADODB.command")

                        set rsf =

server.createobject("ADODB.recordset")

                        cmdf.ActiveConnection =

Application("FastOra_ConnectionString")    

                        QSQL = "{call

aoppack.getloodetails(?,{resultset 9, APPROVAL_DATE, ACCEPT_DATE, PRIOR_CONDS_MET_DATE })}"

                        cmdf.CommandText = QSQL

                        cmdf.CommandType = adCmdText         



                        cmdf.Parameters.Append cmdf.CreateParameter(,

adInteger, adParamInput)  

                        rsf.CursorType = adOpenStatic

                        rsf.LockType = adLockReadOnly

 

                        Set rsf.Source = cmdf

            

                        cmdf(0) = request.form("txtLooNumber")

 

                        rsf.open

                        

%>
Received on Tue Sep 14 2004 - 06:59:30 CDT