X
HOME HTML CSS JAVASCRIPT SQL PHP JQUERY XML ASP.NET MORE...
REFERENCES | EXAMPLES | FORUM | ABOUT

ADO Provider Property


Connection Object Reference 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


Connection Object Reference Complete Connection Object Reference

Your suggestion:

Close [X]

Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

WEB BUILDING

Download XML Editor FREE Website BUILDER Free HTML5 Templates FREE Website Templates Free HTML Templates

SHARE THIS PAGE

facebook