* * HELP & MANUAL PREMIUM PACK 4 DEMO VERSION * *
This documentation was styled with a demo skin from the Premium Pack 4 add-on for Help & Manual. The contents of the skin are encrypted and not configurable. You can only publish HM projects with this skin. You cannot edit it or change it.
This version is copyright and may only be used for local testing purposes. It may not be distributed.
Please purchase the full version of the Premium Pack to get the configurable skins and remove this notice. The package will also include the Toolbox configuration utility for Premium Pack skins.
Description
Sets or returns a string value that contains the provider name for a specific Connection object.
Syntax
GET
s = <ADODB_Connection>.Provider
SET
<ADODB_Connection>.Provider = sProvider
Returns
String: current PROVIDER string.
Parameters
Name |
Type |
Optional |
Meaning |
sProvider |
String |
Yes |
pROVIDER CODE |
Remarks
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.
Restrictions
Never set the provider for a specific Connection in more than one place.
See also
Examples
Uses "Console"
Uses "ADODB"
'---Declare a new pConnection variable and instantiate it in one line
Dim pConn As New ADODB_CONNECTION
'---Specify provider
pConn.Provider = "Microsoft.Jet.OLEDB.4.0"
'---Open connection with only MSAccess DB Name
pConn.Open APP_SourcePath & "Biblio.mdb"
'---Print some info
PrintL pConn.Provider
PrintL pConn.ConnectionString
'---Close connection
pConn.Close
