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


The information in this article applies to:

  • Microsoft Visual InterDev 6.0
  • Microsoft OLE DB Provider for Oracle 2.0
  • Microsoft OLE DB Provider for Oracle 2.1
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.

REFERENCES

For additional information about the Microsoft OLE DB Provider for Oracle, click the article number below to view the article in the Microsoft Knowledge Base:

240205 PRB: ADO Parameter.Refresh Fails with MSDAORA Provider and Parameterized Query

This article assumes that you have configured Microsoft Internet Information Server (IIS) correctly to Oracle. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

193225 How to Configure IIS to Connect to Oracle from ASP and ADO

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://msdn.microsoft.com/dataaccess

Modification Type:MajorLast Reviewed:3/14/2003
Keywords:kbCtrl kbDSupport kberrmsg kbExcel123Quattro kbOracle kbprb kbStoredProc KB240338
©2002 Microsoft Corporation. All rights reserved.