HOWTO: Configure Aqua Data Studio to connect to FireBird

Find out how to get things done with Servoy. Post how YOU get things done with Servoy

HOWTO: Configure Aqua Data Studio to connect to FireBird

Postby Jan Aleman » Mon Nov 10, 2003 11:59 pm

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:

http://www.aquafold.com/

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]
Attachments
ads.png
Overview of the settings
ads.png (44.07 KiB) Viewed 5255 times
Jan Aleman
Servoy
Jan Aleman
 
Posts: 2083
Joined: Wed Apr 23, 2003 9:49 pm
Location: Planet Earth

Return to How To

Who is online

Users browsing this forum: No registered users and 8 guests