HEndNoDatabaseAccess (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

HFSQL Client/Server functions

HEndNoDatabaseAccess

Presentation

Example

Connection to a blocked database

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

HAddScheduledOptimization

HCS.Timeout (Variable)

HDeleteScheduledBackup

HDeleteScheduledOptimization

HExecuteScheduledBackup

HExecuteScheduling

HInfoBackup

HInfoDatabaseProperty

HListScheduledOptimization

HModifyDatabaseProperty

HModifyDatabaseRights

HModifyFileProperty

HModifyFileRights

HModifyGroup

HModifyScheduledBackup

HModifyScheduledOptimization

HModifyScheduling

HModifyServerProperty

HNotifAddEmailRecipient

HNotifConfigure

HNotifDeleteCCRecipient

HNotifDeleteEmailRecipient

HNotifListCCRecipient

HNotifListEmailRecipient

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: The access to the databases had been previously blocked with HNoDatabaseAccess.

Versions 17 and later

This function is now available for iPhone/iPad applications.

New in version 17

This function is now available for iPhone/iPad applications.

Versions 18 and later

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Windows Store apps mode.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 22 and later

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for the Java applications.

New in version 22

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for the Java applications.

This function is now available in Android Widget mode.

This function is now available for Android applications.

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> [, <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>: Character string (with or without quotes) 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 Connection variable.

<Database>: Optional character string (with quotes)

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):

// 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 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,
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 : wd250hf.dll