PROPERTY:

 

 

 

 

 

 

 

 

 

 

DESCRIPTION:

 

 

 

Indicates the name of the provider.

 

 

 

 

 

 

PROPERTY OF:

 

 

 

ADODatabase

 

 

 

 

 

 

DEFAULT VALUE:

 

 

 

MSDASQL

 

 

 

 

 

 

 

DESCRIPTION:

 

 

 

Use the provider property to set the name of the provider for a database connection.

 

 

 

 

 

Provider Short Name:

Provider Full Name:

 

 

ADSDSOObject

Microsoft OLE DB Provider for Microsoft Active Directory Service

 

 

Microsoft.Jet.OLEDB.4.0

Microsoft OLE DB Provider for Microsoft Jet

 

 

MSDAIPP.DSO

Microsoft OLE DB Provider for Internet Publishing

 

 

MSDAORA

Microsoft OLE DB Provider for Oracle

 

 

MSDAOSP

Microsoft OLE DB Simple Provider

 

 

MSDASQL

Microsoft OLE DB Provider for ODBC

 

 

MSDataShape

Microsoft Data Shaping Service for OLE DB

 

 

MSPersist

Microsoft OLE DB Persistence Provider

 

 

SQLOLEDB

Microsoft OLE DB Provider for SQL Server

 

 

MSIDXS

Microsoft OLE DB Provider for Microsoft Indexing Service

 

 

MS Remote

Microsoft OLE DB Remoting Provider

 

 

 

 

 

 

 

 

 

 

 

 

 

This property can also be set by the contents of the connectionString property.

 

 

 

 

 

You can set the provider property only when the ADODatabase object is closed.