<Connection variable>.EndNoDatabaseAccess (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

<Connection variable>.EndNoDatabaseAccess (Function)

In french: <Variable Connexion>.FinInterditAccè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.

Note Access to databases had previously been prevented using <Connection variable>.NoDatabaseAccess.

Example

// Describe the connection
MyConnection is Connection

IF MyConnection.NoDatabaseAccess("CustomerDatabase") = True THEN
	// Specific process
	...
	MyConnection.EndNoDatabaseAccess("CustomerDatabase") 
END

Syntax

<Result> = <Connection>.EndNoDatabaseAccess([<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>: Connection variable

Name of the Connection variable that describes the connection containing the database to which access must be restored.

<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 <Connection variable>.NoDatabaseAccess):

// Description de la connexion
MaConnexion is Connection

// Ouverture de la connexion
MaConnexion.OpenConnection()
IF MaConnexion.NoDatabaseAccess("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 <Connection variable>.EndNoDatabaseAccess.

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