CtDescribedOLEDBProvider (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

CtDescribedOLEDBProvider

Presentation

Example

See also

HFSQL properties

CtDescribedOLEDBProvider (Property)

In french: CxProviderOLEDBDécrit

Available only with this kind of connection

The Property CxProviderOLEDBDecrit allows to manage the name of the OLE DB provider (also called OLE DB server). You can:

Find out the name of the OLE DB provider used for the connection to a table by OLE DB. This provider was defined in the data model editor or when the data file was described by programming.
Caution: The Property CxProviderOLEDBDecrit does not take into account any modifications made with the HConnect function. .
This property can be used for a data 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 by OLE DB (when the data file was described by programming). This property is equivalent to CtOLEDBProvider.

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 name of the OLE DB provider
Customer.CtDescribedOLEDBProvider = hOledbOracle
...
// Validate the data file description
HDescribeFile(Customer)

Syntax

Finding out the OLE DB provider used Hide the details

<OLE DB provider> = <Data file>.CtDescribedOLEDBProvider

<OLE DB provider>: Character string

Name of OLE DB provider or one of the following constants:
hAccessHF7 Pseudo-connection to HFSQL Classic database.
hAccessHFClientServer Native Connector to an HFSQL Client/Server database.
hNativeAccessAS400 Native AS/400 Connector (optional module of WINDEV/WEBDEV).
hNativeAccessDB2 Native DB2 Connector (optional module of WINDEV/WEBDEV).
hNativeAccessInformix Native Informix Connector (optional module of WINDEV/WEBDEV).
Versions 20 and later
hNativeAccessMariaDB
New in version 20
hNativeAccessMariaDB
hNativeAccessMariaDB Native MariaDB Connector (optional module of WINDEV/WEBDEV)
hNativeAccessMySQL Native MySQL Connector (optional module of WINDEV/WEBDEV).
hNativeAccessOracle Native Oracle Connector (optional module of WINDEV/WEBDEV).
hNativeAccessOracleLite Native Oracle Connector (optional module of WINDEV Mobile).
hNativeAccessPostgreSQL Native PostgreSQL Connector (optional module of WINDEV/WEBDEV).
hNativeAccessProgress Native Progress Connector (optional module of WINDEV/WEBDEV).
Versions 16 and later
hNativeAccessSQLAzure
New in version 16
hNativeAccessSQLAzure
hNativeAccessSQLAzure Native SQL Azure Connector (optional module of WINDEV/WEBDEV, supplied with Native SQL Server Connector).
Versions 16 and later
hNativeAccessSQLite
New in version 16
hNativeAccessSQLite
hNativeAccessSQLite Native SQLite Connector (supplied with WINDEV/WEBDEV).
hNativeAccessSQLServer Native SQL Server Connector (optional module of WINDEV/WEBDEV).
hNativeAccessSQLServerMobile Native Connector SQL Server (optional module of WINDEV Mobile).
hNativeAccessSybase Native Sybase Connector (optional module of WINDEV/WEBDEV).
hNativeAccessXBase Native xBase Connector (supplied with WINDEV/WEBDEV).
hNativeAccessXML Native XML Connector (supplied 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.

<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>.CtDescribedOLEDBProvider = <OLE DB provider>

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

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

<OLE DB provider>: Character string

Name of the OLE DB provider or one of the following constants:
hAccessHF7 Pseudo-connection to HFSQL Classic database.
hAccessHFClientServer Native Connector to an HFSQL Client/Server database.
hNativeAccessAS400 Native AS/400 Connector (optional module of WINDEV/WEBDEV).
hNativeAccessDB2 Native DB2 Connector (optional module of WINDEV/WEBDEV).
hNativeAccessInformix Native Informix Connector (optional module of WINDEV/WEBDEV).
Versions 20 and later
hNativeAccessMariaDB
New in version 20
hNativeAccessMariaDB
hNativeAccessMariaDB Native MariaDB Connector (optional module of WINDEV/WEBDEV)
hNativeAccessMySQL Native MySQL Connector (optional module of WINDEV/WEBDEV).
hNativeAccessOracle Native Oracle Connector (optional module of WINDEV/WEBDEV).
hNativeAccessOracleLite Native Oracle Connector (optional module of WINDEV Mobile).
hNativeAccessPostgreSQL Native PostgreSQL Connector (optional module of WINDEV/WEBDEV).
hNativeAccessProgress Native Progress Connector (optional module of WINDEV/WEBDEV).
Versions 16 and later
hNativeAccessSQLAzure
New in version 16
hNativeAccessSQLAzure
hNativeAccessSQLAzure Native SQL Azure Connector (optional module of WINDEV/WEBDEV, supplied with Native SQL Server Connector).
Versions 16 and later
hNativeAccessSQLite
New in version 16
hNativeAccessSQLite
hNativeAccessSQLite Native SQLite Connector (supplied with WINDEV/WEBDEV).
hNativeAccessSQLServer Native SQL Server Connector (optional module of WINDEV/WEBDEV).
hNativeAccessSQLServerMobile Native Connector SQL Server (optional module of WINDEV Mobile).
hNativeAccessSybase Native Sybase Connector (optional module of WINDEV/WEBDEV).
hNativeAccessXBase Native xBase Connector (supplied with WINDEV/WEBDEV).
hNativeAccessXML Native XML Connector (supplied 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

CtOLEDBProvider is used to find out and modify the OLE DB provider.