Provider Property - ADO

Indicates the name of the provider for a Connection object.

Applies To

Connection

Required Files

msado15.dll
VC: adoint.h, adoid.h

Settings and Return Values

Sets or returns a String value.

Remarks

Use the Provider property to set or return the name of the provider for a connection. This property can also be set by the contents of ConnectionString property or the ConnectionString argument of the Open method; however, specifying a provider in more than one place while calling the Open method can have unpredictable results. If no provider is specified, the property will default to MSDASQL (Microsoft ODBC Provider for OLE DB).

The Provider property is read/write when the connection is closed and read-only when it is open. The setting does not take effect until you either open the Connection object or access the Properties collection of the Connection object. If the setting is invalid, an error occurs.

For information on Microsoft ODBC Provider for OLE DB and OLE DB providers in general, see the documentation for the Microsoft® OLE DB SDK or visit the Microsoft OLE DB web page.

See Also

ADO Providers


© 1997 Microsoft Corporation. All rights reserved. Terms of Use.