PRB: Error Calling an Oracle Parameterized Query or Stored Procedure Using the Visual Interdev 6.0 Recordset DTC

• Microsoft Visual InterDev, version 6.0
• Microsoft OLE DB Provider for Oracle, versions 2.0, 2.1

SYMPTOMS

When using the Microsoft OLE DB Provider for Oracle within a data connection in Visual InterDev, the following errors may occur when trying to pass a parameter to a parameterized query or stored procedure called by a recordset design-time control (DTC):

Provider error '8000ffff'
Catastrophic failure

-or-

Microsoft OLE DB Provider for Oracle '80040E51'
Provider cannot derive parameter information and SetParameterInfo has not been called.

CAUSE

The recordset DTC uses the Parameters.Refresh method of the Active Data Objects (AD0) command object to determine parameter information for the query. However, the Microsoft OLE DB Provider for Oracle does not return the parameters collection back to ADO; hence ADO returns the error.

RESOLUTION

To resolve the error, use the Microsoft ODBC Driver for Oracle when creating a data connection to Oracle in Visual InterDev.

STATUS

This behavior is by design for the Microsoft OLE DB Provider for Oracle.

REFERENCES

Please see the Microsoft Universal Data Access Web site for additional information on ADO and to download the latest version of the Microsoft Data Access Components (MDAC):

http://www.microsoft.com/data

Additional query words: kbGrpASP kbvisID600 kbCtrl kbDatabase kbOracle

Keywords : kbCtrl kbOLEDB200 kbOLEDB210 kbOracle kbVisID600 kbGrpASP kbDSupport
Version : WINDOWS:2.0,2.1,6.0
Platform : WINDOWS
Issue type : kbprb