Microsoft OLE DB Provider for Oracle


The Microsoft OLE DB Provider for Oracle allows ADO to access Oracle databases.

Connection String Parameters

To connect to this provider, set the Provider argument of the ConnectionString property to:

MSDAORA

Reading the Provider property will return this string as well.

If a join query with a keyset or dynamic cursor is executed in an Oracle database, an error occurs.
Oracle only supports a static read-only cursor.

Typical Connection String

A typical connection string for this provider is:

"Provider=MSDAORA;Data Source=serverName;User ID=userName; Password=userPassword;"

Consisting of these keywords:

Keyword Description 
Provider Specifies the OLE DB Provider for Oracle. 
Data Source Specifies the name of a server. 
User ID Specifies the user name. 
Password Specifies the user password.