Provider (Property)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

See also

HFSQL properties

Provider (Property)

In french: Provider

Not available with this kind of connection

..Provider is used to manage the type of connection (HFSQL Client/Server, OLE DB, etc.). You can:

Find out 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 opened, it will be closed then re-opened with the new parameters during a first access to a data file that is using this connection.

Note: The connection can correspond to:

a connection described in the data model editor,
a connection described by HConnect, HDescribeConnection or HOpenConnection.
a connection described by a Connection variable.

Note: From version 19, HFSQL is the new name of HyperFileSQL.

Example

MyConnection is Connection
// Describe the 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 name> = <Connection name>..Provider

<Provider name>: String constant

Type of connection used:
hAccessHF7 Pseudo-connection to HFSQL Classic database
hAccessHFClientServer Native Access to HFSQL Client/Server database
hNativeAccessAS400 Native AS/400 Access (optional module of WINDEV/WEBDEV)
hNativeAccessDB2 Native DB2 Access (optional module of WINDEV/WEBDEV)
hNativeAccessInformix Native 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)
hNativeAccessMySQL Native MySQL Access (optional module of WINDEV/WEBDEV)
hNativeAccessOracle Native Oracle Access (optional module of WINDEV/WEBDEV)
hNativeAccessOracleLite Native Oracle Access (optional module of WINDEV Mobile)
hNativeAccessPostgreSQL Native PostgreSQL Access (optional module of WINDEV/WEBDEV)
hNativeAccessProgress Native 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 Native SQL Server Access)
Versions 16 and later
hNativeAccessSQLite
New in version 16
hNativeAccessSQLite
hNativeAccessSQLite Native SQLite access (supplied with WINDEV/WEBDEV)
hNativeAccessSQLServer Native SQL Server Access (optional module of WINDEV/WEBDEV)
hNativeAccessSybase Native Sybase Access (optional module of WINDEV/WEBDEV)
hNativeAccessXBase Native xBase Access (supplied with WINDEV/WEBDEV)
hNativeAccessXML Native XML Access (supplied 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 name>: Character string (with or without quotes)

Name of connection used. This name was defined:
in the data model editor,
by HDescribeConnection or HOpenConnection,
by the Connection type.

Modifying the type of the connection used Hide the details

<Connection name>..Provider = <Provider name>

<Connection name>: Character string (with or without quotes)

Name of connection used. This name was defined:
in the data model editor,
by HDescribeConnection or HOpenConnection,
by the Connection type.

<Provider name>: String constant

Type of connection used:
hAccessHF7 Pseudo-connection to HFSQL Classic database
hAccessHFClientServer Native Access to HFSQL Client/Server database
hNativeAccessAS400 Native AS/400 Access (optional module of WINDEV/WEBDEV)
hNativeAccessDB2 Native DB2 Access (optional module of WINDEV/WEBDEV)
hNativeAccessInformix Native 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)
hNativeAccessMySQL Native MySQL Access (optional module of WINDEV/WEBDEV)
hNativeAccessOracle Native Oracle Access (optional module of WINDEV/WEBDEV)
hNativeAccessOracleLite Native Oracle Access (optional module of WINDEV Mobile)
hNativeAccessPostgreSQL Native PostgreSQL Access (optional module of WINDEV/WEBDEV)
hNativeAccessProgress Native 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 Native SQL Server Access)
Versions 16 and later
hNativeAccessSQLite
New in version 16
hNativeAccessSQLite
hNativeAccessSQLite Native SQLite access (supplied with WINDEV/WEBDEV)
hNativeAccessSQLServer Native SQL Server Access (optional module of WINDEV/WEBDEV)
hNativeAccessSybase Native Sybase Access (optional module of WINDEV/WEBDEV)
hNativeAccessXBase Native xBase Access (supplied with WINDEV/WEBDEV)
hNativeAccessXML Native XML Access (supplied with WINDEV/WEBDEV)

Remarks

..CtOLEDBProvider is used to define and find out the type of access on a data file handled by a connection. This property is kept for backward compatibility. We recommend that you use ..Provider.