OLEDBProvider Property

Specifies the name of the OLE DB data provider currently selected.

Syntax

object.OLEDBProvider[= String]

Parameters

The OLEDBProvider property syntax has these parts:

Part

Description

object

An object expression that evaluates to an object in the Applies To list.

String

An OLE DB data provider name, as described below.

The following table identifies values for String and identifies its corresponding data provider.

String

Description

SQLOLEDB

SQL Server

MSDAORA

Oracle Server

Microsoft.Jet.OLEDB.3.51

Microsoft Jet 3.51 data provider

Microsoft.Jet.OLEDB.4.0

Microsoft Jet 4.0 data provider

MSDAOSP

Simple provider

MS Remote

MS Remote

MS DataShape

MS DataShape

Remarks

The table above shows the default set of data providers installed by ADO 2.1. See the documentation for your OLE Provider if you are using another provider.

See Also