ADO Provider Attribute
Definition and Usage
The Provider property can set or return a string value that contains the provider name of a specific Connection object. The default is MSDASQL (Microsoft OLE DB provider for ODBC). See Provider Code.
This property is read/write when the connection is closed.
The provider name can also be set through the ConnectionString property of the Connection object or the ConnectionString parameter of the Open method.
Note:Please do not set the provider for a specific Connection at multiple places.
Syntax
connobj.Provider
Instance
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
response.write(conn.Provider)
conn.close
%>
Provider Code
| 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 |
