Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Steps

  1. Download and install the latest 64-bit DBVisualizer from the download section of http://www.dbvis.com/.

    Info
    • For Windows it is recommended to download the DBVisualizer 64-bit with embedded JRE. This way it is guaranteed that the firebird driver is always started with 64-bit java.
    • !! Install DBVisualizer in a directory that does not contain any spaces !!


  2. Extract dbvis_addons.zip into the DBVisualizer installation directory (e.g. jdbc subfolder and dlls are copied into the DBVisualizer installation directory).
  3. Start DBVisualizer (e.g. ignore / close the DriverManager).
  4. Import dbvis_settings.jar using File->Import settings. Restart when DBVisualizer prompts to restart.
  5. In the list of connections, right-Click on a suitable connection example and duplicate it.
  6. Edit the new connection and put in the correct connection details.
  7. If the connection doesn't work because of some Java class couldn't be loaded: add the DbVisualizer installation dir to the PATH system environment variable (either using Windows Explorer or using setx /m command) 

Example urls for each local datastore database

Derby

Image Added

jdbc:derby:d:\fews\OC\localDataStore\local.derby

Firebird

Image Added

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:\FEWSfews\testfews\EFASOC\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

?lc_ctype=UTF-8

Hsqldb

Image Added

jdbc:hsqldb:file:d:\fews\OC\localDataStore\local.hsqldb\hsqldb

...