|
|
|
|
|
|
|
|
|
|
- Connection to a blocked database
- Authorizing the access to a database locked by the HFSQL Control Center
<Connection variable>.EndNoDatabaseAccess (Función)
 Disponible solo con este tipo de conexión
Re-allows the access (which means the connection) to one or more databases accessible via a connection.
MaConnexion is Connection
IF MaConnexion.InterditAccèsBaseDeDonnées("BaseClient") = True THEN
...
MaConnexion.FinInterditAccèsBaseDeDonnées("BaseClient")
END
Sintaxis
<Result> = <Connection>.EndNoDatabaseAccess([<Database>])
<Result>: Booleano - 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>: Variable de tipo Connection Name of the Connection variable that describes the connection containing the database to which access must be restored. <Database>: Cadena de caracteres opcional 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>. Observaciones 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):
MaConnexion is Connection
MaConnexion.OuvreConnexion()
IF MaConnexion.InterditAccèsBaseDeDonnées("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".
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|