Provider

Description

Identifies the data provider you want to use to connect to your data source.

When to specify Provider You must specify the Provider parameter before connecting to the database.

Applies to

OLE DB

Syntax

Provider='provider_name'

Default

None

Usage

Select a data provider from the list of installed data providers displayed in the Provider drop-down list. For example, if you are using Microsoft’s OLE DB Provider for ODBC, select MSDASQL as the Provider value. If you are using Microsoft’s OLE DB Provider for SQL Server, select SQLOLEDB as the Provider value.

For more information, see the documentation provided by your OLE DB data provider.

Examples

Example 1

To use the Microsoft OLE DB Provider for ODBC to connect to the EAS Demo DB, select MSDASQL from the Provider drop-down list on the Connection page in the Database Profile Setup dialog box for OLE DB.

Example 2

To use the Microsoft OLE DB Provider for Oracle to connect to an Oracle 8 database, select MSDAORA from the Provider drop-down list on the Connection page in the Database Profile Setup dialog box.