|
|
|
|
|
|
|
|
|
|
Provider (Property) In french: Provider
The Provider property is used to manage the type of a connection (HFSQL Client/Server, OLE DB, etc.). You can: - Get the type of a connection (HFSQL Client/Server, OLE DB, etc.).
- Define the type used for the connection (HFSQL Client/Server, OLE DB, etc.). In this case, if the connection is currently open, it will be closed and opened again with the new parameters when first accessing a data file that uses this connection.
Remark: The connection can correspond to:
MyConnection is Connection
MyConnection.User = "USER"
MyConnection.Password = "PASSWORD"
MyConnection.Server = "MYSERVER"
MyConnection.Database = "Database"
MyConnection.Provider = hAccessHFClientServer
MyConnection.Access = hOReadWrite
MyConnection.ExtendedInfo = "Extended information"
MyConnection.CursorOptions = hClientCursor
HOpenConnection(MyConnection)
Syntax
Finding out the type of the connection used Hide the details
<Provider> = <Connection used>.Provider
<Provider>: String constant Type of connection used:
| | | 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) | | hNativeAccessSybase | Native Sybase Connector (optional module of WINDEV/WEBDEV) | | hNativeAccessXBase | Native xBase Connector (included 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 | | hOledbDBase5 | OLE DB provider for dBase 5 | | 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 |
<Connection used>: Character string or Connection variable Name of the connection used. This name is defined:
Modifying the type of the connection used Hide the details
<Connection>.Provider = <Provider>
<Connection>: Character string or Connection variable Name of the connection used. This name is defined: <Provider>: String constant Type of connection used:
| | | 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) | | hNativeAccessSybase | Native Sybase Connector (optional module of WINDEV/WEBDEV) | | hNativeAccessXBase | Native xBase Connector (included 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 | | hOledbDBase5 | OLE DB provider for dBase 5 | | 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 |
Remarks The CtOLEDBProvider property is used to define and get the type of access to a data file handled by a connection. This property is kept for backward compatibility. It is recommended to use the Provider property.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|