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.