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
Whether you're new to XML or already an advanced user,
the user-friendly views and powerful entry helpers,
wizards, and debuggers in XMLSpy are designed to meet your XML
and Web development needs from start to finish.
New features in Version 2010!
- XML editor
- Graphical XML Schema / DTD editors
- XSLT 1.0/2.0 editor, debugger, profiler
- XQuery editor, debugger, profiler
- XBRL validator, taxonomy editor, taxonomy wizard
- Support for Office Open XML (OOXML)
- Graphical WSDL 1.1/2.0 editor & SOAP debugger
- JSON editing & conversion
- Java, C#, C++ code generation
- And much more!
Download a free trial today!
|
|
|
|
