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:\broek_f\FEWS\testfews\EFAS\localDataStore\local.fdb
username: sysdba
password: masterkey
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)