ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
  • Undefined status
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
HServerStatus (Function)
In french: HEtatServeur
HFSQL Client/ServerAvailable only with this kind of connection
Allows you to find out the status of a HFSQL server (this function uses the MantaManager service).
Example
// Status of a server identified by the computer name
SWITCH HServerStatus("MyServer:4905")
CASE hStopped: Info("Server stopped")
CASE hStarted: Info("Server started")
CASE hInaccessible: Info("Server not available")
END
// Status of a server identified by a Connection variable
Cnt_HFSQL is Connection
Cnt_HFSQL.Provider = hAccessHFClientServer
Cnt_HFSQL.User = "admin"
Cnt_HFSQL.Password = ""
Cnt_HFSQL.Server = "GB:4916"
Cnt_HFSQL.Database = "CRM"
 
SWITCH HServerStatus(Cnt_HFSQL.Server)
CASE hStopped: Info("Server stopped")
CASE hStarted: Info("Server started")
CASE hInaccessible: Info("Server not available")
END
Syntax

Status of a server (with ability to specify the port of the HFSQL server) Hide the details

<Result> = HServerStatus(<Computer name>)
<Result>: Integer constant
Status of the HFSQL server:
hInaccessibleUndefined server status
hStartedServer started
hStoppedServer stopped
<Computer name>: Character string
Server name. The port number used by the HFSQL server can be specified. The port 4900 will be used by default. If the port number of the HFSQL server is different, use the following notation:
<Computer name>:<Port number>
Example: "ComputerName:4901"
The port number corresponds to the port number used in HOpenConnection.

Status of a server while specifying the name of the HFSQL server Hide the details

<Result> = HServerStatus(<Computer name> , <Name of the HFSQL server>)
<Result>: Integer constant
Status of the HFSQL server:
hInaccessibleUndefined server status
hStartedServer started
hStoppedServer stopped
<Computer name>: Character string
Name of server.
<Name of the HFSQL server>: Character string
Name of the HFSQL server to restart (this name appears in the HFSQL Control Center).

Status of a server while specifying a connection Hide the details

<Result> = HServerStatus(<Connection name>)
<Result>: Integer constant
Status of the HFSQL server:
hInaccessibleUndefined server status
hStartedServer started
hStoppedServer stopped
<Connection name>: Character string
Name of the connection for which the status of the server must be checked. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.
Remarks

Undefined status

The status of the server is undefined when no connection to MantaManager can be established. This failure to connect may be caused by the following problems:
  • The MantaManager service is not started,
  • The MantaManager service does not respond,
  • A firewall prevents from accessing the MantaManager service,
  • ...
You must restart the MantaManager service from the service manager of Windows and you must check whether port 5002 or port 4999 is opened (no firewall or antivirus).
Business / UI classification: Business Logic
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/05/2023

Send a report | Local help