PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
CtDescribedOLEDBProvider (Property)
In french: CxProviderOLEDBDécrit
OLE DBAvailable only with this kind of connection
..CtDescribedOLEDBProvider is used 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: ..CtDescribedOLEDBProvider ignores the possible modifications performed by HConnect.
    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.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Define the name of the OLE DB provider
Customer..CtDescribedOLEDBProvider = hOledbOracle
...
// Validates the description of data file
HDescribeFile(Customer)
Syntax

Finding out the OLE DB provider used Hide the details

<OLE DB provider> = <File name>..CtDescribedOLEDBProvider
<OLE DB provider>: Character string
Name of OLE DB provider or one of the following constants:
hAccessHF7Pseudo-connection to HFSQL Classic database.
hAccessHFClientServerNative Access to HFSQL Client/Server database.
hNativeAccessAS400Native AS/400 access (optional module of WINDEV/WEBDEV).
hNativeAccessDB2Native DB2 access (optional module of WINDEV/WEBDEV).
hNativeAccessInformixNative Informix access (optional module of WINDEV/WEBDEV).
Versions 20 and later
hNativeAccessMariaDB
New in version 20
hNativeAccessMariaDB
hNativeAccessMariaDB
Native MariaDB Access (optional module of WINDEV/WEBDEV)
hNativeAccessMySQLNative MySQL access (optional module of WINDEV/WEBDEV).
hNativeAccessOracleNative Oracle access (optional module of WINDEV/WEBDEV).
hNativeAccessOracleLiteNative Oracle access (optional module of WINDEV Mobile).
hNativeAccessPostgreSQLNative PostgreSQL access (optional module of WINDEV/WEBDEV).
hNativeAccessProgressNative Progress access (optional module of WINDEV/WEBDEV).
Versions 16 and later
hNativeAccessSQLAzure
New in version 16
hNativeAccessSQLAzure
hNativeAccessSQLAzure
Native SQL Azure access (optional module of WINDEV/WEBDEV supplied with the Native SQL Server access).
Versions 16 and later
hNativeAccessSQLite
New in version 16
hNativeAccessSQLite
hNativeAccessSQLite
Native SQLite access (supplied with WINDEV/WEBDEV).
hNativeAccessSQLServerNative SQL Server access (optional module of WINDEV/WEBDEV).
hNativeAccessSQLServerMobileNative SQL Server access (optional module of WINDEV Mobile).
hNativeAccessSybaseNative Sybase access (optional module of WINDEV/WEBDEV).
hNativeAccessXBaseNative xBase access (supplied with WINDEV/WEBDEV).
hNativeAccessXMLNative XML access (supplied 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.
Versions 19 and later
hOledbAccess2010
New in version 19
hOledbAccess2010
hOledbAccess2010
OLE 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 (setup performed by WINDEV and when creating the client version),
  • install the OLE DB provider corresponding to the database used.
<File name>: 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

<File name>..CtDescribedOLEDBProvider = <OLE DB provider>
<File name>: 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 OLE DB provider or one of the following constants:
hAccessHF7Pseudo-connection to HFSQL Classic database.
hAccessHFClientServerNative Access to HFSQL Client/Server database.
hNativeAccessAS400Native AS/400 access (optional module of WINDEV/WEBDEV).
hNativeAccessDB2Native DB2 access (optional module of WINDEV/WEBDEV).
hNativeAccessInformixNative Informix access (optional module of WINDEV/WEBDEV).
Versions 20 and later
hNativeAccessMariaDB
New in version 20
hNativeAccessMariaDB
hNativeAccessMariaDB
Native MariaDB Access (optional module of WINDEV/WEBDEV)
hNativeAccessMySQLNative MySQL access (optional module of WINDEV/WEBDEV).
hNativeAccessOracleNative Oracle access (optional module of WINDEV/WEBDEV).
hNativeAccessOracleLiteNative Oracle access (optional module of WINDEV Mobile).
hNativeAccessPostgreSQLNative PostgreSQL access (optional module of WINDEV/WEBDEV).
hNativeAccessProgressNative Progress access (optional module of WINDEV/WEBDEV).
Versions 16 and later
hNativeAccessSQLAzure
New in version 16
hNativeAccessSQLAzure
hNativeAccessSQLAzure
Native SQL Azure access (optional module of WINDEV/WEBDEV supplied with the Native SQL Server access).
Versions 16 and later
hNativeAccessSQLite
New in version 16
hNativeAccessSQLite
hNativeAccessSQLite
Native SQLite access (supplied with WINDEV/WEBDEV).
hNativeAccessSQLServerNative SQL Server access (optional module of WINDEV/WEBDEV).
hNativeAccessSQLServerMobileNative SQL Server access (optional module of WINDEV Mobile).
hNativeAccessSybaseNative Sybase access (optional module of WINDEV/WEBDEV).
hNativeAccessXBaseNative xBase access (supplied with WINDEV/WEBDEV).
hNativeAccessXMLNative XML access (supplied 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.
Versions 19 and later
hOledbAccess2010
New in version 19
hOledbAccess2010
hOledbAccess2010
OLE 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 (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.
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment