Firebird Documentation IndexFirebird ODBC/JDBC Driver ManualThe Services Interface → Exploring the ODBC Services Console
Firebird Home Firebird Home Prev: The Services InterfaceFirebird Documentation IndexUp: The Services InterfaceNext: Using the Services API

Exploring the ODBC Services Console

Table of Contents

Showing Logs from the Interface

To use the console, open that configuration page and click the button in the centre, labelled “Services”:

Figure 7.1. Launching the Services UI on Windows

Launching the Services UI on Windows


The console is a tabbed display providing access to many of the Services API functions, with the Backup tab on top.

Figure 7.2. Firebird ODBC Services console—Backup tab

Firebird ODBC Services console—Backup tab


Figure 7.3. Restore tab

Restore tab


Figure 7.4. Statistics tab

Statistics tab


We selected “Header pages”, which produced the gstat -h report for our database. Clicking on the “View Log” button delivers the output to the browser:

Figure 7.5. Statistics log

Statistics log


Of course, you can have any statistics report, the Firebird log, metadata reports and more.

The Repair tab gives easy access to most of the gfix housekeeping functions:

Figure 7.6. Repair tab

Repair tab


The Users tab could be used to maintain accounts in the security database of any version of Firebird prior to V.3.0, although the Services API method was discouraged from V.2.5 onward. The Services API method is still available to maintain users in Firebird 3 databases if they were defined using Legacy_Auth authentication management. It will not work with users defined with the default SRP authentication manager.

Figure 7.7. Users tab

Users tab


Click on the appropriate button to add, modify or delete a user. Remember, the user performing these tasks must be SYSDBA or a user with elevated server privileges. The role RDB$ADMIN is not sufficiently elevated.

Figure 7.8. Add user

Add user


Figure 7.9. Modify user

Modify user


Figure 7.10. Delete user

Delete user


Showing Logs from the Interface

If a log file is available from the execution of a Service API function, the “View Log” button will become active. The UI provides it on demand in HTML format and opens it in your default browser. If you wonder how to go about coding this into your own ODBC application, the source code is a resource that is freely available to you.

Prev: The Services InterfaceFirebird Documentation IndexUp: The Services InterfaceNext: Using the Services API
Firebird Documentation IndexFirebird ODBC/JDBC Driver ManualThe Services Interface → Exploring the ODBC Services Console