HServerStatus (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | French

HFSQL Client/Server functions

HAddScheduledOptimization

HCS.Timeout (Variable)

HDeleteScheduledBackup

HDeleteScheduledOptimization

HExecuteScheduledBackup

HExecuteScheduling

HInfoBackup

HInfoDatabaseProperty

HListScheduledOptimization

HModifyDatabaseProperty

HModifyDatabaseRights

HModifyFileProperty

HModifyFileRights

HModifyGroup

HModifyScheduledBackup

HModifyScheduledOptimization

HModifyScheduling

HModifyServerProperty

HNotifAddEmailRecipient

HNotifConfigure

HNotifDeleteCCRecipient

HNotifDeleteEmailRecipient

HNotifListCCRecipient

HNotifListEmailRecipient

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 a HFSQL server (this function uses the MantaManager service).

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

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

<Computer name>: Character string (with quotes)

Name of server. 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 HFSQL server>)

<Result>: Integer constant

Status of the HFSQL server:
hStopped Server stopped
hStarted Server started
hInaccessible Undefined server status

<Computer name>: Character string (with quotes)

Name of server.

<Name of HFSQL server>: Character string (with or without quotes)

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

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

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 : wd250hf.dll