Getting Started - Databases

Previous  Top  Next

In order to debug stored routines, you need to register a database in Hopper. You can do this by using the Register Database button or via the menu, File | Register Database. This will open up the Register Database Wizard.

 

Depending on the edition of Hopper that you're using, this will display a window with different options.

 

Important note!

Registration details, including the database password, are stored in plain text in a file in your Windows profile. You can use the Always prompt for password checkbox to avoid storing the password.

 

Registering a Firebird or InterBase Database

When you register a Firebird or InterBase database, you get a window similar to the one below.

 

Registering a Firebird database

 

Alias

A user defined alias for use in Hopper, for display purposes only

 

Hostname

The host name or IP address of the machine running the Firebird server process, if you're using TCP on a non default port, use the /<number> syntax (see screenshot above)

 

If you're running an instance of InterBase not on the default port, make sure to use the instance name behind the hostname, eg: myserver/gdsXE

 

Protocol

 

Network protocol used to connect

 

Database

 

The database filename, including the full path, as defined on the server (so no "mapped drives")

 

Username

User name to connect

 

Password

Password for the given user name, use Always prompt for password to avoid saving the password

 

Characterset

Optional character set to use when connecting to this database

 

Client library

Optional client library, if none is entered, Hopper will attempt to load "fbclient.dll" as defined per Windows path, if it's not available in the path, browse for a client library

 

Use Test Connection to check to see if the details are correct, if so, the Finish button becomes enabled and you can use the database with Hopper.

 

Registering a MySQL Database

When you register a MySQL database, you get a window similar to the one below.

 

Registering a MySQL database

 

Alias

 

A user defined alias for use in Hopper, for display purposes only

Hostname

 

The host name or IP address of the machine running the MySQL server process

Port

 

Port number on which this instance of MySQL is listening

Database

 

The database on the server that you would like to connect to

Username

 

User name to connect

Password

Password for the given user name, use Always prompt for password to avoid saving the password

 

Use Test Connection to check to see if the details are correct, if so, the Finish button becomes enabled and you can use the database with Hopper.

 

Modifying registration properties

If you select a database from the treeview, you can modify its registration properties by using the context menu or the Database Registration Properties button from the toolbar. This will display the registration properties, just as when registering a database.