HEndNoDatabaseAccess (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

Connection to a blocked database
Authorizing the access to a database locked by the HFSQL Control Center

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HEndNoDatabaseAccess (Function)

In french: HFinInterditAccèsBaseDeDonnées

Available only with this kind of connection

Re-allows the access (which means the connection) to one or more databases accessible via a connection.

Remark: Access to databases had previously been prevented by HNoDatabaseAccess.

Example

IF HNoDatabaseAccess("MaConnexion", "BaseClient") = True THEN
	// Traitement spécifique
	...
	HEndNoDatabaseAccess("MaConnexion", "BaseClient") 
END

Syntax

<Result> = HEndNoDatabaseAccess(<Connection> [, <Database>])

<Result>: Boolean

True if the access to the specified database (or to all the databases accessed by the connection) is restored,
False if an error occurs. HError is used to identify the error.

<Connection>: Character string or Connection variable

Connection containing the database to which access must be restored. This connection corresponds to:
the name of the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
the name of a variable of type Connection.

<Database>: Optional character string

Name of database for which the access must restored.
If this parameter corresponds to "*", access will be restored for all databases.
If this parameter is not specified, access will be restored for all the databases accessible by <Connection>.

Remarks

Connection to a blocked database

In some cases (power failure for example), the connections to a database may be refused. For example, if a power failure occurs during the execution of this code (before HNoDatabaseAccess):

// Description de la connexion
HDescribeConnection("MaConnexion", "Julie", "MotDePasse", "MonServeurHF", ...
		"BaseClient", hAccessHFClientServer, hORead)
// Ouverture de la connexion
HOpenConnection("MaConnexion")
IF HNoDatabaseAccess("MaConnexion", "BaseClient") = True THEN
	Info("Il est impossible de se connecter à la base de données")
END

To authorize access again, simply establish a connection without specifying a database and use HEndNoDatabaseAccess.

Authorizing the access to a database locked by the HFSQL Control Center

When the connections to an HFSQL Client/Server database are refused, access can be granted again using HFSQL Control Center. To do so, perform the following operations:

Connect as administrator to the server without specifying the database,
Go to the "Connections" tab of server,
In the ribbon, in the "Connections" group, expand the "Lock of connections" button and select "Authorize all the connections".

Component: wd300hf.dll