Registering a Database

Previous  Index  Next  How To Use

InterBase 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 InterBase 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 InterBase 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 InterBase 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.