ADO Provider Property
Complete Connection Object Reference
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.
Syntax
connobj.Provider
Example
<%
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 Codes
| 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 |
Complete Connection Object Reference
