Allows you to find out the status of a HFSQL server (this function uses the MantaManager service).
// 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: | |
| 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"
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
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: | |
| 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