CtOLEDBProvider (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

See also

CtOLEDBProvider (Property)

In french: CxProviderOLEDB

Available only with this kind of connection

CtOLEDBProvider is used to manage the name of the OLE DB provider (also called OLE DB server). You can:

Find out the name of the provider used for the connection to a table via OLE DB. The name of the provider can correspond to:
- the OLE DB provider defined in the data model editor,
- the OLE DB provider specified in HConnect (if this function was used).
  This property can be used for a file defined in the data model editor or by programming.
Define the name of the OLE DB provider used for the connection to a table via OLE DB (only when the data file is described by programming).
In this case, this property is equivalent to CtDescribedOLEDBProvider.

Reminder: HConnect is used to redefine one or more parameters of the OLE DB connection to a table. By default, the characteristics of the OLE DB connection are defined:

in the data model editor during the description of the data file,
when the data file is described by programming.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Example

// Define the OLE DB provider used
Customer.CtOLEDBProvider = hOledbOracle
...
// Validate the data file description
HDescribeFile(Customer)

Syntax

Finding out the OLE DB provider used Hide the details

<Provider name> = <Data file>.CtOLEDBProvider

<Provider name>: Character string

Name of OLE DB provider or one of the following constants:
hAccessHF7 Pseudo-connection to HFSQL Classic database
hAccessHFClientServer Native/Native Connector access to an HFSQL Client/Server base
hNativeAccessAS400 Native/Native Connector AS/400 access (optional module of WINDEV/WEBDEV)
hNativeAccessDB2 Native/Native Connector DB2 access (optional module of WINDEV/WEBDEV)
hNativeAccessInformix Native/Native Connector Informix access (optional module of WINDEV/WEBDEV)
Versions 20 and later
hNativeAccessMariaDB
New in version 20
hNativeAccessMariaDB
hNativeAccessMariaDB Native/Native Connector access MariaDB (optional module of WINDEV/WEBDEV)
hNativeAccessMySQL Native/Native Connector MySQL access (optional module of WINDEV/WEBDEV)
hNativeAccessOracle Native/Native Oracle Connector access (optional module of WINDEV/WEBDEV)
hNativeAccessOracleLite Native/Native Oracle Connector access (optional module of WINDEV Mobile)
hNativeAccessPostgreSQL Native/Native Connector PostgreSQL access (optional module of WINDEV/WEBDEV)
hNativeAccessProgress Native/Native Connector Progress access (optional module of WINDEV/WEBDEV)
Versions 16 and later
hNativeAccessSQLAzure
New in version 16
hNativeAccessSQLAzure
hNativeAccessSQLAzure Native Access/Native Connector SQL Azure (optional module of WINDEV/WEBDEV, provided with Native Access/Native SQL Server Connector)
Versions 16 and later
hNativeAccessSQLite
New in version 16
hNativeAccessSQLite
hNativeAccessSQLite Native/Native Connector SQLite access (supplied as standard with WINDEV/WEBDEV)
hNativeAccessSQLServer Native/Native SQL Server Connector access (optional module of WINDEV/WEBDEV)
hNativeAccessSQLServerMobile Native/Native Connector SQL Server Access (optional module of WINDEV Mobile)
hNativeAccessSybase Native/Native Connector Sybase access (optional module of WINDEV/WEBDEV)
hNativeAccessXBase Native/Native Connector xBase access (supplied as standard with WINDEV/WEBDEV)
hNativeAccessXML Native/Native Connector XML access (supplied as standard with WINDEV/WEBDEV)
hODBC OLE DB provider for ODBC (used to access an ODBC data source declared in the ODBC data sources of Windows)
hOledbAccess97 OLE DB provider for Access 97
hOledbAccess2000 OLE DB provider for Access 2000
hOledbAccess2007 OLE DB provider for Access 2007
Versions 19 and later
hOledbAccess2010
New in version 19
hOledbAccess2010
hOledbAccess2010 OLE DB provider for Access 2010
hOledbDBase5 OLE DB provider for dBase 5
hOledbExcel2007 OLE DB provider for Excel 2007
hOledbExcel2000 OLE DB provider for Excel 2000
hOledbExcel97 OLE DB provider for Excel 97
hOledbLotus4 OLE DB provider for Lotus 4
hOledbOracle OLE DB provider for Oracle
hOledbSQLServer OLE DB provider for SQL Server

Caution: To use an OLE DB connection, you must:
install MDAC version 2.6 or later (setup performed by WINDEV/WEBDEV and when creating the setup version),
install the OLE DB provider corresponding to the database used.

<Data file>: Character string (with or without quotes)

Name of data file used. This name was defined in the data model editor or by the File description type.

Defining the OLE DB provider used Hide the details

<Data file>.CtOLEDBProvider = <Provider name>

<Data file>: Character string (with or without quotes)

Name of data file used. This name was defined by the File description type.

<Provider name>: Character string

Name of OLE DB provider or one of the following constants:
hAccessHF7 Pseudo-connection to HFSQL Classic database
hAccessHFClientServer Native/Native Connector access to an HFSQL Client/Server base
hNativeAccessAS400 Native/Native Connector AS/400 access (optional module of WINDEV/WEBDEV)
hNativeAccessDB2 Native/Native Connector DB2 access (optional module of WINDEV/WEBDEV)
hNativeAccessInformix Native/Native Connector Informix access (optional module of WINDEV/WEBDEV)
Versions 20 and later
hNativeAccessMariaDB
New in version 20
hNativeAccessMariaDB
hNativeAccessMariaDB Native/Native Connector access MariaDB (optional module of WINDEV/WEBDEV)
hNativeAccessMySQL Native/Native Connector MySQL access (optional module of WINDEV/WEBDEV)
hNativeAccessOracle Native/Native Oracle Connector access (optional module of WINDEV/WEBDEV)
hNativeAccessOracleLite Native/Native Oracle Connector access (optional module of WINDEV Mobile)
hNativeAccessPostgreSQL Native/Native Connector PostgreSQL access (optional module of WINDEV/WEBDEV)
hNativeAccessProgress Native/Native Connector Progress access (optional module of WINDEV/WEBDEV)
Versions 16 and later
hNativeAccessSQLAzure
New in version 16
hNativeAccessSQLAzure
hNativeAccessSQLAzure Native Access/Native Connector SQL Azure (optional module of WINDEV/WEBDEV, provided with Native Access/Native SQL Server Connector)
Versions 16 and later
hNativeAccessSQLite
New in version 16
hNativeAccessSQLite
hNativeAccessSQLite Native/Native Connector SQLite access (supplied as standard with WINDEV/WEBDEV)
hNativeAccessSQLServer Native/Native SQL Server Connector access (optional module of WINDEV/WEBDEV)
hNativeAccessSQLServerMobile Native/Native Connector SQL Server Access (optional module of WINDEV Mobile)
hNativeAccessSybase Native/Native Connector Sybase access (optional module of WINDEV/WEBDEV)
hNativeAccessXBase Native/Native Connector xBase access (supplied as standard with WINDEV/WEBDEV)
hNativeAccessXML Native/Native Connector XML access (supplied as standard with WINDEV/WEBDEV)
hODBC OLE DB provider for ODBC (used to access an ODBC data source declared in the ODBC data sources of Windows)
hOledbAccess97 OLE DB provider for Access 97
hOledbAccess2000 OLE DB provider for Access 2000
hOledbAccess2007 OLE DB provider for Access 2007
Versions 19 and later
hOledbAccess2010
New in version 19
hOledbAccess2010
hOledbAccess2010 OLE DB provider for Access 2010
hOledbDBase5 OLE DB provider for dBase 5
hOledbExcel2007 OLE DB provider for Excel 2007
hOledbExcel2000 OLE DB provider for Excel 2000
hOledbExcel97 OLE DB provider for Excel 97
hOledbLotus4 OLE DB provider for Lotus 4
hOledbOracle OLE DB provider for Oracle
hOledbSQLServer OLE DB provider for SQL Server

Caution: To use an OLE DB connection, you must:
install MDAC version 2.6 or later (setup performed by WINDEV and when creating the client version),
install the OLE DB provider corresponding to the database used.

Remarks

CtDescribedOLEDBProvider is used to find out and modify the type of access specified for the OLE DB connection when describing the data file.