Upgrading from ADO 2.7 to ADO 2.81
- From: "David Sabatino" <DavidSabatino@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 3 Sep 2005 01:39:01 -0700
Recently I upgraded from ADO 2.7 to the latest (2.81).
My application was VBA based, so I had to use ADO with VB 6.0 style calling
etc. rather than using .Net (which as better support for Oracle).
My application is calling packages (stored procedures) that return the data
via refcursors in an Oracle database, and was retrieving the information
without any problems when using the 2.7 version of the MSDORA provider.
Since installing MDAC 2.81, the recordset is not populated, and an error
event is raised. The connection still opens OK, but when I call the Oracle
package via the command.execute call, no records are returned.
The oracle package returns a refcursor data type, and I know the package is
being executed, as the error code indicating "No records returned" is a
user-defined error code being raised explicitly by the Oracle package code.
Even if I change my project references to select the old ADO version (2.7)
it still doesn't work.
As there is no way to uninstall MDAC 2.8, I am contemplating re-imaging the
PC so that I can get it back to the pre-MDAC 2.8 state.
Has anyone else seen this phenomena? Are there any workarounds? Any help
would be appreciated.
Here are some further details of what I am doing:
Connection Object:
connection.connectionstring = "Provider=MSDAORA;Data Source=CRFMDEV;User
ID=xxxxxx;Password=xxxxxx;PLSQLRSet=1;"
connection.CursorLocation = adUseClient
connection.Mode = adModeRead
Recordset Object:
recordset.CursorLocation = adUseClient
recordset.CursorType = adOpenStatic
Command Object:
Set Command.ActiveConnection = connection
Command.CommandText = "package_name"
Command.CommandType = adCmdStoredProc
Command.Parameters.Append .CreateParameter("parm_name", adBSTR,
adParamInput, , modMain.strLocation)
Then I make the following call to retrieve the recordset:
set Recordset = Command.Execute
.
- Follow-Ups:
- Re: Upgrading from ADO 2.7 to ADO 2.81
- From: BigFish
- Re: Upgrading from ADO 2.7 to ADO 2.81
- Prev by Date: Re: Getting Column Order MS Access, or Copy Table
- Next by Date: adding and retriving data from SQL server to VB.net webapp
- Previous by thread: Overlapping Updates
- Next by thread: Re: Upgrading from ADO 2.7 to ADO 2.81
- Index(es):
Relevant Pages
|
