With Aqua Data Studio (ADS) you can execute SQL statements against a variety of SQL databases. FireBird is not supported out of the box but you can configure it in a few steps. You can download Aqua Data Studio here:
Just like Servoy it’s built in Java and runs on all operating systems. If you want to manage FireBird databases and are on Windows I recommend a different tool though: EMS FireBird Manager (http://www.ems-hitech.com), this tool doesn’t exist for Mac OS X in which case Aqua Data Studio comes in the picture.
After installation launch ADS and start to register a Server. In the Generic RDBMS list choose Generic-JDBC. Then fill in the following values:
Name: whatever you like to name the connection
Login Name: sysdba
Password: masterkey
URL: jdbc:firebirdsql:localhost/3050:/Applications/Servoy12rc8/database/USER_DATA.GDB?lc_ctype=WIN1252
NOTE: adjust path and filename as necessary! In the example above “/Applications/Servoy12rc8/database/” is the path and USER_DATA.GDB is the databasename.
Driver: org.firebirdsql.jdbc.FBDriver
Driver Location: Navigate to your Servoy folder, then drivers choose Firebird.zip
[/b]