Microsoft KB Archive/240338

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

Article ID: 240338

Article Last Modified on 3/14/2003

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition
 * Microsoft OLE DB Provider for Oracle Server 1.0
 * Microsoft OLE DB Provider for Oracle Server 1.0

-



This article was previously published under Q240338



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.

