My Oracle Support Banner

Oracle OLEDB Provider - General Information and Common Questions (Doc ID 90016.1)

Last updated on OCTOBER 30, 2023

Applies to:

Oracle Provider for OLE DB - Version 10.2.0.1 to 11.2.0.1 [Release 10.2 to 11.2]
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)

Purpose

This FAQ provides general information and common questions on Oracle OLEDB Provider.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 What is the Oracle OLEDB Provider and how does it work?
 What version of the Oracle client software must I have to be able to use Oracle OLEDB Provider in my code?
 What version of the Oracle Database may I run against using Oracle OLEDB Provider?
 What are the system requirements needed to use the Oracle OLEDB Provider?
 Does Oracle OLEDB provider support LOBs?
 I receive "Run-Time error: '-2147217900 (80040e14)'" when trying to run a stored procedure. How can I overcome this error?
 How do I establish a connection to the database?
 Can I use O.S. Authentication with the Oracle OLEDB Provider?
 Are query timeouts supported by the Oracle OLEDB Provider?
 How can I execute a stored procedure with the Oracle OLEDB Provider?
 Are there limitations on the size of large objects (BLOB, CLOB, NCLOB, BFILE)?
 Does Oracle OLEDB support complex datatypes?
 When I execute my code the following error is generated: 'ADO could not find the specified provider', what is the cause of this error?
 I would like to update a rowset which is created using a REF CURSOR. Is this possible?
 Why does the Microsoft OLE DB Provider and the Oracle OLEDB Provider return different string lengths on VARCHAR2?
 Why am I seeing differences in values for a scaled decimal variant?
 I receive the following error when I call my stored procedure: 'ORA-00900: invalid SQL Statement.' What causes this error?
 Does Oracle OLEDB Provider support the .NET Framework?
 Does Oracle OLEDB Provider support multiple Oracle Homes?
 Does Oracle OLEDB Provider support Kerberos Authentication?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.