Page History
...
Aqua Data Studio (ADS) supports Firebird Database Schema. Firebird is a very popular RDBMS maintained by the Firebird Project at SourceForge.
Contents
Table of Contents |
---|
...
You may locate the latest Firebird JDBC drivers at the following location ...
Vendor: Firebird
Website: http://www.firebirdsql.org
Download Page: http://www.firebirdsql.org/en/downloads/
Driver URL: http://www.firebirdsql.org/en/jdbc-driver/
Database Product: Firebird
Description: Firebird is an open-source relational database offering many ANSI SQL standard features that runs run on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names, since 1981.
...
Firebird tutorial for Aqua Data Studio to Connect Firebird Database
Create Server Group | Register a FirebirdServer | Enter Properties | Locate Firebird Driver |
Firebird Driver Properties | Firebird Server in ADS | Firebird Schema | Creating tables in Firebird |
...
- Download Firebird Relational Database Engine and Install the RDBMS.
- Download Firebird JDBC driver from the url URL given above to your local machine
- Create a new server Group and name it as Firebird
- Right Click on server group and click on the the Item which displays Register Server
- Provide a new name for the Firebird Server
- In the General tab, pick Generic - JDBC
- Specify a URL. Enter
jdbc:firebirdsql:localhost/3050:C:\\pathtodatabase\\SampleDB.FDB
where SampleDB is the Firebird database you want to Connect to (only windows user require paths to be formatted with escaped \, likeC:\\pathtodatabase\\SampleDB.FDB
;while Linux and OSX would use/pathtodatabase/SampleDB.FDB
) - Provide
org.firebirdsql.jdbc.FBDriver
in the Driver field - Locate the the the downloaded driver by clicking on Browse. For e.g the downloaded driver in this sample is jaybird-full-2.2.1.jar
...