PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Connecting to a locked 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
HEndNoDatabaseAccess (Function)
In French: HFinInterditAccè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.
Note: The access to the databases was forbidden by HNoDatabaseAccess.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
Java This function is now available for the Java applications.
New in version 22
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
Java This function is now available for the Java applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
Java This function is now available for the Java applications.
Example
IF HNoDatabaseAccess("MyConnection", "CustomerDatabase") = True THEN
        // Specific process
        ...
        HEndNoDatabaseAccess("MyConnection", "CustomerDatabase")
END
Syntax
<Result> = HEndNoDatabaseAccess(<Connection Name> [, <Database Name>])
<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 Name>: Character string (with or without quotes)
Name of connection containing the database whose access must be restored. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.
If only this parameter is specified, all the databases using this connection will have their access restored.
<Database Name>: Optional character string (with quotes)
Name of database for which the access must restored.
If this parameter corresponds to "*", the access will be restored for all the databases.
If this parameter is not specified, the access will be restored for all the databases accessible by <Connection Name>.
Remarks

Connecting to a locked 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):
// Describe the connection
HDescribeConnection("MyConnection", "Julia", "Password", "MyHFServer", ...
"CustomerDatabase", hAccessHFClientServer, hORead)
// Open the connection
HOpenConnection("MyConnection")
IF HNoDatabaseAccess("MyConnection", "CustomerDatabase") = True THEN
Info("Unable to connect to the database")
END
To authorize the accesses again, all you have to do is 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 a HFSQL Client/Server database are refused, the access can be authorized again via the 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".
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment