From Fishbowl Inventory

[edit] DB Tools

Dbtools (Database Tools) is an application that allows you to view and edit the information in your database without using Fishbowl.

Warning: Dbtools is an advanced feature that may make irreversible changes to your database if used incorrectly. In this document, we provide a read-only username and password. If, by chance, you come across a full access username and password and make any changes to the datafile on your own accord, Fishbowl will be forced to void your support contract.

• To begin, find and click on the dbtools icon in the following directory (assuming Fishbowl was installed to the default location):

            C:\Program Files\Fishbowl\Server\bin\dbtools.bat

Once the application has started, you will need to review the following steps to open a JDBC driver.

1. In the upper left corner click File | JDBC Jars… or click on the JDBC drivers button   located below File to open the Drivers window.
2. Click the Open icon on the right side of the JDBC Drivers window
   
3. Browse to the C:\Program Files\Fishbowl\lib\ directory, scroll to the right and open the ‘firebirdsql-full-2.1.1.jar’ file (the numbers at the end may vary).
   
   Your screen should look like this*:
    
   
        
   

*Note: If by chance you have the FirebirdDriver but not the FBDriver that is created, simply highlight the firebirdsql-full-2.1.1.jar and sent it to the trash can. Then repeat steps 1-3. This should now bring up both drivers.

You may now close out of the Drivers window. This will take you back to the Database Tools Window.

• Next, you will setup the database you want to connect to. To do this, click on the New Database Details button.   Enter the following data into the appropriate lines:

Alias = Your company name

Driver = Click on the drop down arrow and select org.firebirdsql.jdbc.FBDriver.

URL = Choose jdbc:firebirdsql://<server>/<path to .fdb file> from the drop down menu.

• Change the <server> tag to your server and/or port location (for example: localhost or the IP address of the server if it is on a different computer).
• Next, change <path to .fdb file> to the file path where your database is located (for example: Program Files\Fishbowl\database\data\_________.fdb).
• You can find the name of your database by right clicking on the server tray icon and clicking “show.” Fishbowl databases always end with .fdb.

Username =gone

Password = fishing

Click “OK” to close the Database Details and go back to Database Tools.

On the left side you should now see your company's name in the white column (as shown left below).

Highlight your company name and click the green play icon

Your company name should show a green light and the database tables will be visible (as shown right).

If by chance you receive a red light instead of a green one and the tables are not visible, the file paths are likely incorrect. Go back to your Database Details window and check to ensure the Driver, URL, Username and Password are correct.

If you continue to experience difficulty, please contact our technical support staff at 1-800-774-7085 ext 3 or e-mail support@fishbowlinventory.com

---

Return to Support