The Provider property sets or returns a string value that contains the provider name for a specific Connection object. Default is MSDASQL (Microsoft OLE DB provider for ODBC). Look at Provider Codes
This property is read/write when the connection is closed.
The provider name can also be set with the ConnectionString property of the Connection object or the ConnectionString parameter of the Open method.
Note: Never set the provider for a specific Connection in more than one place.
Provider Code | Provider |
---|---|
ADSDSOObject | Active Directory Services |
Microsoft.Jet.OLEDB.4.0 | Microsoft Jet databases |
MSDAIPP.DSO.1 | Microsoft Internet Publishing |
MSDAORA | Oracle databases |
MSDAOSP | Simple text files |
MSDASQL | Microsoft OLE DB provider for ODBC |
MSDataShape | Microsoft Data Shape |
MSPersist | Locally saved files |
SQLOLEDB | Microsoft SQL Server |