ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

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
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
<Connection variable>.EndNoDatabaseAccess (Function)
In french: <Variable Connexion>.FinInterditAccèsBaseDeDonnées
HFSQL Client/ServerAvailable only with this kind of connection
Re-allows the access (which means the connection) to one or more databases accessible via a connection.
Remark: The access to the databases had been previously blocked with <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 occurred. 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):
// Describe the connection
MyConnection is Connection
 
// Open the connection
MyConnection.OpenConnection()
IF MyConnection.NoDatabaseAccess("CustomerDatabase") = True THEN
Info("Unable to connect to the database")
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,
  • Display 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: wd290hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help