Microsoft OLE DB Provider for Oracle Overview


This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use Oracle's OLE DB provider.

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:


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=MyUserID; Password=MyPassword;"

The string consists 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.


If you are connecting to a data source provider that supports Windows authentication, you should specify Trusted_Connection=yes or Integrated Security = SSPI instead of user ID and password information in the connection string.

Provider-Specific Connection Parameters

The provider supports several provider-specific connection parameters in addition to those defined by ADO. As with the ADO connection properties, these provider-specific properties can be set via the Properties collection of a Connection or as part of the ConnectionString.

These parameters are fully described in the OLE DB Programmer's Reference. The ADO Dynamic Property Index provides a cross-reference between these parameter names and the corresponding OLE DB properties.

Parameter Description
Window Handle Indicates the window handle to use to prompt for additional information.
Locale Identifier Indicates a unique 32-bit number (for example, 1033) that specifies preferences related to the user's language. These preferences indicate how dates and times are formatted, items are sorted alphabetically, strings are compared, and so on.
OLE DB Services Indicates a bitmask that specifies OLE DB services to enable or disable.
Prompt Indicates whether to prompt the user while a connection is being established.
Extended Properties A string containing provider-specific, extended connection information. Use this property only for provider-specific connection information that cannot be described through the property mechanism.

See Also

ConnectionString Property (ADO) Provider Property (ADO) Recordset Object (ADO)