Provider (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / WLanguage properties / HFSQL properties

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HFSQL properties

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:

a connection defined in the data model editor,
a connection defined with HConnect, HDescribeConnection or HOpenConnection.
a connection described with a variable of type Connection.

Example

MaConnexion is Connection
// Description de la connexion
MaConnexion.User = "USER"
MaConnexion.MotDePasse = "PASSWORD"
MaConnexion.Server = "MONSERVEUR"
MaConnexion.Database = "Base de données"
MaConnexion.Provider = hAccessHFClientServer
MaConnexion.Access = hOReadWrite
MaConnexion.ExtendedInfo = "Infos étendues"
MaConnexion.CursorOptions = hClientCursor

HOpenConnection(MaConnexion)

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 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 (included 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:
in the data model editor,
with HDescribeConnection or HOpenConnection,
with the Connection type.

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:
in the data model editor,
with HDescribeConnection or HOpenConnection,
with the Connection type.

<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 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 (included with WINDEV/WEBDEV)

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.