Setting Up ODBC (Firebird 3 64-Bit)


For those companies that use ODBC, the Build 397 (and above) update requires that you use a 64-bit version of the Firebird ODBC.   If you were previously using the 32-bit version you will need to uninstall and reinstall the new 64-bit ODBC driver.


ODBC Definition: Short for Open Database Connectivity, a standard database access method developed by SQL Access group in 1992. The goal of ODBC is to make it possible to access any data from any application regardless of which database management system (DBMS) is handling the data. ODBC manages this by inserting a middle layer, called a database driver, between the application and the DBMS (the Firebird database for DBA). The purpose of this layer is to translate the application's data queries and commands that the DBA Firebird understands. For this to work, both the application and the DBA Firebird database must be ODBC-compliant.


Warning: ODBC is meant to be used as "read only" access to our database. Writing to our data tables can cause irreparable harm. Please refer to the rules and restrictions section in the following document.


DBA Data Dictionary


DBA does not come with a built in ODBC driver. In order to communicate with other databases or applications that are ODBC compliant you will need to install an ODBC driver for the Firebird/Interbase database. The following ODBC driver is recommended.


Link for Firebird_ODBC_2.0.4.155_x64.exe 


(Note: If clicking the above link does not work, click on the link from the Firebird SQL Downloads page)


Step One: Download and Install an ODBC Driver


Download the ODBC driver above and install by following the instructions from the developer.  The driver should be installed on any PC that requires ODBC.


Step Two: Setup ODBC on your Windows Server


You will need to open the ODBC Data Source Administrator.  You can find ODBC in the Windows Control Panel by searching for ODBC.


Once you are in the ODBC Data Source Administrator (64-bit), do these steps:


  • Select System DSN Tab
  • Select Add
  • Select the Firebird/Interbase ODBC driver you previously installed.
  • Type a Data Source Name (DSN) such as DBA.
  • Specify the new Firebird driver. This should prefill from your previous selection.
  • Browse and select the path to the DBA system database file. This is your ejdb.fdb file and should be located in the database folder of your DBA Manufacturing program directory. You will need to also include the name of the server (or your PC name if a standalone install) and a colon before the path (see the example below where we have installed DBA to it's default location on the server and the server's computer name is SERVERNAME).
  • Enter Database Account name = SYSDBA (must be all caps)
  • Password = masterkey
  • Test the connection



Step Three: Setup ODBC on your workstation


There are special instructions you need to follow to set up DBA at your DBA Client workstation  PC:


  • Copy the fbclient.dll file from the C:\Program Files\Firebird\Firebird_3_0  directory from the server onto your local PC, and reference that file in the CLIENT field in the ODBC setup. In the example below, I created a C:\Firebird folder on the local workstation and placed the fbclient.dll file in that folder.


Install the ODBC driver, and you will need to open the ODBC Data Source Administrator.  You can find ODBC in the Windows Control Panel by searching for ODBC.


Once you are in the ODBC Data Source Administrator (64-bit), do these steps:

  • Select System DSN Tab
  • Select Add
  • Select the Firebird/Interbase ODBC driver you previously installed.
  • Type a Data Source Name (DSN) such as DBA.
  • Specify the new Firebird driver. This should prefill from your previous selection.
  • Browse and select the path to the DBA system database file. This is your ejdb.fdb file and should be located in the database folder of your DBA Manufacturing program directory. You will need to also include the name of the server (or your PC name if a standalone install) and a colon before the path (see the example below)
  • Browse and select the fbclient.dll file you copied from the server onto your local PC in the Client field
  • Enter Database Account name = SYSDBA
  • Password = masterkey
  • Test the connection



WARNING: Do not edit database tables!!!

Under no circumstances should any DBA Manufacturing table be directly edited using DB Console or any other tool. THIS CAN CAUSE SEVERE AND IRREPARABLE HARM TO YOUR DATA, for which there is no remedy.


Special Note for DBA Classic Customers:  If you are a former DBA Classic customer accustomed to using the old system's database maintenance program, please be aware that DBA Next-Gen's Firebird database is a completely different technology than the Pervasive database used by DBA Classic. Firebird is a single table, relational database that uses automatic triggers and numerous and complicated linkages among fields and tables. If you delete linked records or edit the wrong fields, you can destroy critical data relationships that can't be recovered.