This page contains the explanation and files for Firebird version 1.5 (up till build 17455)
For Firebird version 2.0 look at HOW-TO look at a Firebird 2.1 database
See attachments for files
copy the following files to the c:\Program Files\DbVisualizer-4.3.4\drivers directory:
fbembed.dll
firebird.conf
firebirdsql-full.jar
ib_util.dll
jaybird.dll
and to c:\Program Files\DbVisualizer-4.3.4
fbembed.dll
firebird.conf
ib_util.dll
jaybird.dll
use firebirdsql-full.jar as JDBC driver in DBVisualizer.
URL: jdbc:firebirdsql:embedded:<filename.fdb>
e.g.
jdbc:firebirdsql:embedded:d:\FEWS\testfews\EFAS\localDataStore\local.fdb
username: sysdba
password: masterkey
Only one process can access the local.fdb file at one time. To look at e.g. an OC localdatastore, exit the OC before accessing the localdatastore with DBVisualizer and vice versa.
Tips and tricks
The wildcard for texts when using the Like statement is % (e.g. Select * from TimeSeries where moduleInstanceId Like '%Import%')- When looking for a date in an SQL string - use CAST('yyyy-MM-dd HH:mm:ss' as TIMESTAMP)
(this is equivalent to the ORACLE to_Date command)
