Quick References
ADO
ASP
CSS2
HTML
JavaScript
Jet SQL
VBScript
WML
WMLScript
WSH
XHTML
XML DOM
XSLT
Features
Knowledge Base
Tutorials
Partners
ZVON.ORG
XML
Planet Source Code
VisualBuilder
Web Design
Your HTML Source
XML/XSLT Forums
ASPAlliance
Scripts
Programmers Heaven
Tek-Tips Forums
Developer Fusion
Code Project
ConnectionString Property
Connection Object
Open Method
Properties Collection
PROPERTY: Connection::Provider
string =
connectionobject.
Provider
connectionobject.
Provider
= string
The
Provider
property is used to set or return the name of the provider for a specific
Connection
object. The default is
MSDASQL
(Microsoft OLE DB provider for ODBC).
The provider name can also be set using the
ConnectString
property of the
Connection
object and the
ConnectString
parameter of the
Open
method. You should never set the provider for a specific
Connection
in more than one place.
Obviously, setting an invalid provider will generate an error.
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
Code (VBScript):
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.
Provider
= "Microsoft.Jet.OLEDB.4.0"
...
objConnection.Open strConnect
Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information
