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.
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
| Код Provider | Provider |
|---|---|
| ADSDSOObject | Сервисы Active Directory |
| Microsoft.Jet.OLEDB.4.0 | Базы данных Microsoft Jet |
| MSDAIPP.DSO.1 | Microsoft Internet Publishing |
| MSDAORA | Базы данных Oracle |
| MSDAOSP | Простые текстовые файлы |
| MSDASQL | Microsoft OLE DB provider for ODBC |
| MSDataShape | Microsoft Data Shape |
| MSPersist | Локально сохраненные файлы |
| SQLOLEDB | Microsoft SQL Server |
