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

ADO.NET
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 or ADO.NET data provider.

Examples

Example 1

To use the Microsoft OLE DB Provider for ODBC to connect to the EAS Demo DB:

Database profile Select MSDASQL from the Provider drop-down list on the Connection tab in the Database Profile Setup dialog box for OLE DB.
Application Type the following in code:
```
SQLCA.DBParm="Provider='MSDASQL'"
```

Example 2

To use the Microsoft OLE DB Provider for Oracle to connect to an Oracle 8 database:

Database profile Select MSDAORA from the Provider drop-down list on the Connection tab in the Database Profile Setup dialog box.
Application Type the following in code:
```
SQLCA.DBParm="Provider='MSDAORA'"
```

Example 3

To use the Sybase Oracle8 ADO Provider to connect to an Oracle 8 database:

Database profile Select Sybase.Oracle8ADOProvider from the Provider drop-down list on the Connection tab in the Database Profile Setup dialog box for ADO.NET.

Application Type the following in code:

SQLCA.DBParm = "PROVIDER='Sybase.Oracle8ADOProvider'"