Firebird doesn't keep track of databases on the server machine, therefore you need to register databases that you want to use with Database Workbench.
You can do this by right clicking on the server or Databases node and selecting Register Database or by double clicking the Databases node.
Context sensitive popup menu in the Enterprise Manager
This will show the Register Database wizard:
Register Database Wizard, welcome page
Click next to see the needed database and authentication information:
Register Database Wizard, database page
Alias |
A user defined alias to display in the Enterprise Manager. |
Database |
The full path and file on the server of the database file. If your version of Firebird supports server side aliases, such an alias can be entered here. |
Username |
The username to use when connecting to this database, this defaults to the username you used when registering the server. |
Password |
The password for the given username. |
Role |
The SQL Role that you want to use when connecting to this database. |
SQL Dialect |
The sql dialect (see Firebird documentation) to use when connecting to this database. This defaults to the SQL Dialect entered in the Preferences of Database Workbench. |
Use Unicode Client |
By default, Database Workbench uses Unicode all-over, this means it will use UNICODE_FSS or UTF8 (if available) as the character set when connecting. To avoid this, uncheck this box and select your characterset below. |
Characterset |
The characterset you want to use when connecting to this database. This is an Firebird connection setting and it has nothing to do with displaying anything inside Database Workbench. You can use the A button next to the drop down box to fetch the default characterset from the database, as used when creating the database. |
The next page of the wizard lists the Database Workbench database registration options.