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
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
|