Syntax
| string = connectionobject.Provider
connectionobject.Provider = string
| ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Description
| Sets or returns the string value that is the provider name.
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.
| ||||||||||||||||||||
See Also
| |||||||||||||||||||||
Example
| Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Provider = "Microsoft.Jet.OLEDB.4.0"
...
objConnection.Open strConnect
|