HServerStatus (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions

Undefined status

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HServerStatus (Function)

In french: HEtatServeur

Available only with this kind of connection

Allows you to find out the status of an HFSQL server (this function uses the MantaManager service).

Example

// Etat d'un serveur identifié par le nom du poste
SWITCH HServerStatus("MonServeur:4905")
	CASE hStopped : Info("Serveur arrêté")
	CASE hStarted : Info("Serveur démarré")
	CASE hInaccessible : Info("Serveur inaccessible")
END

// Etat d'un serveur identifié par une variable de type Connexion
Cnx_HFSQL is Connection
Cnx_HFSQL.Provider = hAccessHFClientServer
Cnx_HFSQL.User = "admin"
Cnx_HFSQL.MotDePasse = ""
Cnx_HFSQL.Server = "GB:4916"
Cnx_HFSQL.Database = "CRM"

SWITCH HServerStatus(Cnx_HFSQL.Server)
	CASE hStopped : Info("Serveur arrêté")
	CASE hStarted : Info("Serveur démarré")
	CASE hInaccessible : Info("Serveur inaccessible")
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:
hInaccessible Undefined server status
hStarted Server started
hStopped Server 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:
hInaccessible Undefined server status
hStarted Server started
hStopped Server stopped

<Computer name>: Character string

Server name.

<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:
hInaccessible Undefined server status
hStarted Server started
hStopped Server 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: wd300hf.dll