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
Provider (Property)
In french: Provider
HFSQLNot 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:
Versions 17 and later
iPhone/iPad This property is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This property is now available for the iPhone/iPad applications.
iPhone/iPad This property is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This property is now available in Windows Store Apps mode.
New in version 18
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
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:
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 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)
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
hOledbDBase5OLE DB provider for dBase 5
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
<Connection name>: Character string (with or without quotes)
Name of connection used. This name was defined:

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:
<Provider name>: String constant
Type of connection used:
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 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)
hNativeAccessSybaseNative Sybase Access (optional module of WINDEV/WEBDEV)
hNativeAccessXBaseNative xBase Access (supplied with WINDEV/WEBDEV)
hNativeAccessXMLNative 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.
See also
Minimum version required
  • Version 10
This page is also available for…
Comments
Example
Nagyro.ini
======================
[Nagyro]
Server = 192.168.1.180
User = sa
Password = 777777777
BD = producao
======================


PROCEDURE DB_Inicialize(TrueFalse)

Server, User, Password, BD is string

IF TrueFalse = True THEN

PathFile is string = fCurrentDir(fCurrentDrive()) +"\Nagyro.ini"

IF fFileExist(PathFile) = True THEN

Server = INIRead("Nagyro", "Server", "", PathFile)
IF ErrorOccurred THEN
Error()
END

User = INIRead("Nagyro", "User", "", PathFile)
IF ErrorOccurred THEN
Error()
END

Password = INIRead("Nagyro","Password", "", PathFile)
IF ErrorOccurred THEN
Error()
END

BD = INIRead("Nagyro", "BD", "", PathFile)
IF ErrorOccurred THEN
Error()
END

HCloseConnection(ConnNativa)

ConnNativa..Server = Server
ConnNativa..User = User
ConnNativa..Password = Password
ConnNativa..Database = BD
ConnNativa..Provider = hNativeAccessSQLServer
ConnNativa..Access = hOReadWrite
ConnNativa..ExtendedInfo = "Extended information"
ConnNativa..CursorOptions = hClientCursor

ok is boolean = HOpenConnection(ConnNativa)

IF ok = False
Info(ErrorInfo())
Close()
END

END

END
adrianoboller
09 Feb. 2015