PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Implementing a HFSQL Client/Server application
  • The different steps
  • Compatibility between versions
  • Installing the HFSQL Client/Server server on a LINUX server
  • 32-bit and 64-bit HFSQL Client/Server server
  • HFSQL Client/Server server and IPv6
  • Limitations
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
Overview
You have the ability to create applications that access the HFSQL Client/Server databases.
A HFSQL Client/Server application runs an application on several computers (called client computers) and stores the databases and processes on a server. This operating mode makes response times faster and more reliable, and it simplifies the maintenance of the database.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example with WINDEV applications:
Example with WEBDEV sites:
You can:
  • create a HFSQL Client/Server application from scratch.
  • modify an existing WINDEV, WEBDEV or WINDEV Mobile application into a HFSQL Client/Server application.
Note: To compare the HFSQL Client/Server mode with the HFSQL Network mode, see Operating mode of HFSQL application.
Implementing a HFSQL Client/Server application

The different steps

The steps for implementing a HFSQL Client/Server application are as follows:
  1. Installing a HFSQL server and configuring the server used.
  2. Connecting the client computers to the server.
  3. Configuring the data files on the server.
  4. Using the application.

Compatibility between versions

The different versions of clients and servers are compatible. All the client versions can use all the versions of the server.
However, we advise you to always keep the HFSQL Client/Server engine in its most recent version proposed in the download center, even if all the connected clients (applications and/or sites) are not compiled with the last version.
Note: If the client DLL used is more recent than the server (client DLL in version 18 and server in version 12 for example), the new features will trigger an error such as "The server does not support this feature (server too old)" if they are used by the client application.

Installing the HFSQL Client/Server server on a LINUX server

To install the HFSQL Client/Server server on a LINUX server:
  1. Copy the following files to the server:
    • manta_install
    • mantainstall.zip
    • README
      These files are found in the "HyperFileSQL server\Linux4" sub-directory of setup CD. These files are found in the "HFSQL server\Linux4" sub-directory of setup CD.
  2. Connect to the server as "root"
  3. Run the manta_install file. You can:
    • Install a new server.
    • Update an existing server.
    • Uninstall a server.
  4. Follow the instructions displayed on the screen.
Caution: The license must be entirely scrolled in order to display the following screens.
To install the 64-bit HFSQL Client/Server server on a 64-bit LINUX server:
  1. Copy the following files to the server:
    • manta_install64
    • mantainstall.zip
    • README
      These files are found in the "HyperFileSQL server\Linux44_64" sub-directory of the setup CD. These files are found in the "HFSQL server\Linux44_64" sub-directory of the setup CD.
  2. Connect to the server as "root"
  3. Run the manta_install64 file. You can:
    • Install a new server.
    • Update an existing server.
    • Uninstall a server.
  4. Follow the instructions displayed on the screen.
Caution: The license must be entirely scrolled in order to display the following screens.
Notes:
  • The server will be installed as "Daemon (service)".
  • The following Linux versions are supported by the HFSQL engine for Linux:
    • Linux4 version: Debian 7 (and later), OpenSuse 10.3 (and later)
    • Linux4 version (64 bits): Ubuntu 14 (and later)

32-bit and 64-bit HFSQL Client/Server server

Two versions are available for the HFSQL server: 32-bit mode and 64-bit mode. The HFSQL client is also available in 32-bit mode and in 64-bit mode.
The server in 64-bit mode recognizes the clients in 32-bit mode and the server in 32-bit mode recognizes the clients in 64-bit mode.
Versions 15 and later

HFSQL Client/Server server and IPv6

The HFSQL server supports the IPV6 protocol. If the compute contains a network card configured in IPv6, the HFSQL server will automatically accept the connections by using this protocol on all the network cards configured in IPv6.
The HFSQL server simultaneously supports the connections in IPv6 and in IPv4.
No code modification is required to use the IPv6 protocol. If the name of the server is resolved by the DNS into an IPv6 address, this protocol will be used.
New in version 15

HFSQL Client/Server server and IPv6

The HFSQL server supports the IPV6 protocol. If the compute contains a network card configured in IPv6, the HFSQL server will automatically accept the connections by using this protocol on all the network cards configured in IPv6.
The HFSQL server simultaneously supports the connections in IPv6 and in IPv4.
No code modification is required to use the IPv6 protocol. If the name of the server is resolved by the DNS into an IPv6 address, this protocol will be used.

HFSQL Client/Server server and IPv6

The HFSQL server supports the IPV6 protocol. If the compute contains a network card configured in IPv6, the HFSQL server will automatically accept the connections by using this protocol on all the network cards configured in IPv6.
The HFSQL server simultaneously supports the connections in IPv6 and in IPv4.
No code modification is required to use the IPv6 protocol. If the name of the server is resolved by the DNS into an IPv6 address, this protocol will be used.
Limitations
  • The management mode of data files may have to be adapted when using a HFSQL Client/Server application. See Differences and limitations specific to a HFSQL Client/Server application for more details.
  • The HFSQL server is available for the following operating systems:
    • 32-bit Windows
    • 64-bit Windows
    • 32-bit Linux
    • 64-bit Linux
    It is not available for the other operating systems.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment