Home | About me | EXCEL VB Programming (XL97-2003) | ACCESS Programming | EXCEL VB.Net Programming | EXCEL Spreadsheet Functions |  Material Management  |  Guestbook
 

ADO Provider Property

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

conn.Provider="Microsoft.Jet.OLEDB.4.0"