ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
CtOLEDBProvider (Property)
In french: CxProviderOLEDB
OLE DBAvailable only with this kind of connection
The CtOLEDBProvider property gets and sets the name of the OLE DB provider (also called OLE DB server). You can:
  • Get the name of the provider used to connect 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 data file defined in the data model editor or programmatically.
  • Define the name of the OLE DB provider used to connect to a table via OLE DB (only for data files defined programmatically).
    In this case, this property is equivalent to the CtDescribedOLEDBProvider property.
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 set:
  • when defining the data file in the data model editor,
  • when defining the data file programmatically.
Example
// Defines the OLE DB provider used
Customer.CtOLEDBProvider = hOledbOracle
...
// Validate the data file description 
HDescribeFile(Customer)
Syntax

Getting the OLE DB provider used Hide the details

<Provider name> = <Data file>.CtOLEDBProvider
<Provider name>: Character string
Name of the OLE DB provider or one of the following constants:
hAccessHF7Pseudo-connection to HFSQL Classic database
hAccessHFClientServerNative Connector to an HFSQL Client/Server database
hNativeAccessAS400Native AS/400 Connector (optional module of WINDEV/WEBDEV)
hNativeAccessDB2Native DB2 Connector (optional module of WINDEV/WEBDEV)
hNativeAccessInformixNative Informix Connector (optional module of WINDEV/WEBDEV)
hNativeAccessMariaDBNative MariaDB Connector (optional module of WINDEV/WEBDEV)
hNativeAccessMySQLNative MySQL Connector (optional module of WINDEV/WEBDEV)
hNativeAccessOracleNative Oracle Connector (optional module of WINDEV/WEBDEV)
hNativeAccessOracleLiteNative Oracle Connector (optional module of WINDEV Mobile)
hNativeAccessPostgreSQLNative PostgreSQL Connector (optional module of WINDEV/WEBDEV)
hNativeAccessProgressNative Progress Connector (optional module of WINDEV/WEBDEV)
hNativeAccessSQLAzureNative SQL Azure Connector (optional module of WINDEV/WEBDEV, provided with the Native SQL Server Connector)
hNativeAccessSQLiteNative SQLite Connector (provided with WINDEV/WEBDEV)
hNativeAccessSQLServerNative SQL Server Connector (optional module of WINDEV/WEBDEV)
hNativeAccessSQLServerMobileNative SQL Server Connector (optional module of WINDEV Mobile)
hNativeAccessSybaseNative Sybase Connector (optional module of WINDEV/WEBDEV)
hNativeAccessXBaseNative xBase Connector (provided with WINDEV/WEBDEV)
hNativeAccessXMLNative XML Connector (provided with WINDEV/WEBDEV)
hODBCOLE DB provider for ODBC (used to access an ODBC data source declared in the ODBC data sources of Windows)
hOledbAccess97OLE DB provider for Access 97
hOledbAccess2000OLE DB provider for Access 2000
hOledbAccess2007OLE DB provider for Access 2007
hOledbAccess2010OLE DB provider for Access 2010
hOledbDBase5OLE DB provider for dBase 5
hOledbExcel2007OLE DB provider for Excel 2007
hOledbExcel2000OLE DB provider for Excel 2000
hOledbExcel97OLE DB provider for Excel 97
hOledbLotus4OLE DB provider for Lotus 4
hOledbOracleOLE DB provider for Oracle
hOledbSQLServerOLE DB provider for SQL Server

Caution: To use an OLE DB connection, you must:
  • install MDAC version 2.6 or later (MDAC is provided with WINDEV and WEBDEV, and can be included in the application or site setup program),
  • install the OLE DB provider corresponding to the database used.
<Data file>: Character string
Name of the data file used. This name is defined in the data model editor or with the File Description type.

Defining the OLE DB provider used Hide the details

<Data file>.CtOLEDBProvider = <Provider name>
<Data file>: Character string
Name of the data file used. This name is defined with the File Description type.
<Provider name>: Character string
Name of the OLE DB provider or one of the following constants:
hAccessHF7Pseudo-connection to HFSQL Classic database
hAccessHFClientServerNative Connector to an HFSQL Client/Server database
hNativeAccessAS400Native AS/400 Connector (optional module of WINDEV/WEBDEV)
hNativeAccessDB2Native DB2 Connector (optional module of WINDEV/WEBDEV)
hNativeAccessInformixNative Informix Connector (optional module of WINDEV/WEBDEV)
hNativeAccessMariaDBNative MariaDB Connector (optional module of WINDEV/WEBDEV)
hNativeAccessMySQLNative MySQL Connector (optional module of WINDEV/WEBDEV)
hNativeAccessOracleNative Oracle Connector (optional module of WINDEV/WEBDEV)
hNativeAccessOracleLiteNative Oracle Connector (optional module of WINDEV Mobile)
hNativeAccessPostgreSQLNative PostgreSQL Connector (optional module of WINDEV/WEBDEV)
hNativeAccessProgressNative Progress Connector (optional module of WINDEV/WEBDEV)
hNativeAccessSQLAzureNative SQL Azure Connector (optional module of WINDEV/WEBDEV, provided with the Native SQL Server Connector)
hNativeAccessSQLiteNative SQLite Connector (provided with WINDEV/WEBDEV)
hNativeAccessSQLServerNative SQL Server Connector (optional module of WINDEV/WEBDEV)
hNativeAccessSQLServerMobileNative SQL Server Connector (optional module of WINDEV Mobile)
hNativeAccessSybaseNative Sybase Connector (optional module of WINDEV/WEBDEV)
hNativeAccessXBaseNative xBase Connector (provided with WINDEV/WEBDEV)
hNativeAccessXMLNative XML Connector (provided with WINDEV/WEBDEV)
hODBCOLE DB provider for ODBC (used to access an ODBC data source declared in the ODBC data sources of Windows)
hOledbAccess97OLE DB provider for Access 97
hOledbAccess2000OLE DB provider for Access 2000
hOledbAccess2007OLE DB provider for Access 2007
hOledbAccess2010OLE DB provider for Access 2010
hOledbDBase5OLE DB provider for dBase 5
hOledbExcel2007OLE DB provider for Excel 2007
hOledbExcel2000OLE DB provider for Excel 2000
hOledbExcel97OLE DB provider for Excel 97
hOledbLotus4OLE DB provider for Lotus 4
hOledbOracleOLE DB provider for Oracle
hOledbSQLServerOLE DB provider for SQL Server

Caution: To use an OLE DB connection, you must:
  • install MDAC version 2.6 or later (MDAC is provided with WINDEV and WEBDEV, and can be included in the application or site setup program),
  • install the OLE DB provider corresponding to the database used.
Remarks
The CtDescribedOLEDBProvider property gets and sets the type of access specified for the OLE DB connection when describing the data file.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/14/2024

Send a report | Local help