|
|
|
|
|
CtDescribedOLEDBProvider (Property) In french: CxProviderOLEDBDécrit
Available only with this kind of connection
The CtDescribedOLEDBProvider property gets and sets the name of the OLE DB provider (also called OLE DB server). You can: - Get the name of the OLE DB provider used to connect to a table via OLE DB. This provider is defined in the data model editor or when defining the data file programmatically.
Caution: The CtDescribedOLEDBProvider property ignores any changes made with HConnect. 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). This property is equivalent to the CtOLEDBProvider 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.
Customer.CtDescribedOLEDBProvider = hOledbOracle
HDescribeFile(Customer)
Syntax
Getting the OLE DB provider used Hide the details
<OLE DB provider> = <Data file>.CtDescribedOLEDBProvider
<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). | 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). | hNativeAccessSQLAzure | Native SQL Azure Connector (optional module of WINDEV/WEBDEV, provided with the Native SQL Server Connector). | hNativeAccessSQLite | Native SQLite Connector (provided with WINDEV/WEBDEV). | hNativeAccessSQLServer | Native SQL Server Connector (optional module of WINDEV/WEBDEV). | hNativeAccessSQLServerMobile | Native SQL Server Connector (optional module of WINDEV Mobile). | hNativeAccessSybase | Native Sybase Connector (optional module of WINDEV/WEBDEV). | hNativeAccessXBase | Native xBase Connector (provided with WINDEV/WEBDEV). | hNativeAccessXML | Native XML Connector (provided 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. | 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 (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>.CtDescribedOLEDBProvider = <OLE DB provider>
<Data file>: Character string Name of the data file used. This name is defined with 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). | 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). | hNativeAccessSQLAzure | Native SQL Azure Connector (optional module of WINDEV/WEBDEV, provided with the Native SQL Server Connector). | hNativeAccessSQLite | Native SQLite Connector (provided with WINDEV/WEBDEV). | hNativeAccessSQLServer | Native SQL Server Connector (optional module of WINDEV/WEBDEV). | hNativeAccessSQLServerMobile | Native SQL Server Connector (optional module of WINDEV Mobile). | hNativeAccessSybase | Native Sybase Connector (optional module of WINDEV/WEBDEV). | hNativeAccessXBase | Native xBase Connector (provided with WINDEV/WEBDEV). | hNativeAccessXML | Native XML Connector (provided 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. | 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 (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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|