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
 |
|
Get Your Diploma!
W3Schools' Online Certification Program is the perfect solution for busy
professionals who need to balance work, family, and career building.
The HTML Certificate is for developers who want to document their knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate is for developers who want to document their knowledge of JavaScript and the HTML DOM.
The XML Certificate is for developers who want to document their knowledge of XML, XML DOM and XSLT.
The ASP Certificate is for developers who want to document their knowledge of ASP, SQL, and ADO.
The PHP Certificate is for developers who want to document their knowledge of PHP and SQL (MySQL).
|
|
