This page now contains the explanation and files for Firebird version 2.x (used in current FEWS builds)
See attachments for files
Copy the following files to the c:\Program Files\DbVisualizer-6.x.y directory:
fbembed.dll
icudt30.dll
icuin30.dll
icuuc30.dll
ib_util.dll
jaybird.dll
(NB on some computers you must also copy MSVCP71.dll, this file can be found in the fews bin directory)
Copy the following file to the c:\Program Files\DbVisualizer-6.x.y\lib directory:
connector.jar
Copy jaybird-2.1.6p.jar to c:\Program Files\DbVisualizer-6.x.y\jdbc\firebird
Use jaybird-full-2.1.6.jar (or jaybird-2.1.6p.jar for FEWS) as a JDBC driver in DBVisualizer. Make sure you remove any old firebird/jaybird jars from the DBVisualizer directories and from the DriverManager 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)