Important Content Update Message
We are currently updating the OP Help Center content for the release of OP 20. OP 20 (official version 20.0.x) is the certified, 2015 Edition, version of the Office Practicum software. This is displayed in your software (Help tab > About) and in the Help Center tab labeled Version 20.0. We appreciate your patience as we continue to update all of our content.

ODBC Connection to OP Database

This page outlines how to set up an ODBC connection to an Office Practicum Database.


Note: OP Cloud does not allow an ODBC connection setup.
  1. Download the most recent ODBC connector form the following Website (32 or 64-bit):  http://www.firebirdsql.org/index.php?op=files&id=odbc.
  2. Install the ODBC driver (for example, Firebird_ODBC_2.0.0.148_win32.exe) - default install.
  3. Go to Administrative Tools and open the ODBC Manager "Data Sources (ODBC)".
  4. Create a System DSN (Click the Add button).
  5. Choose Firebird/Interbase driver and click the Finish button.
  6. Configure the settings according to those in the following screen capture:

  • DSN: Specify the name for the DSN. The DSN is the name you use to access the database from any ODBC source (such as MS Access).
  • Driver: IscDbc (always).
  • Description: Description to identify your connection, if you have multiple connections (optional).
  • Database: <servername>:<local path to OP database> (use localhost if you install ODBC on the same machine as the OP database).
  • Client: C:\Windows\System32\gds32.dll (if you have OP installed and on a 32bit machine).
Warning: If you are using a 64bit machine you need to install the 64bit Firebird client and set the Client dll to: c:\windows\system32\fbclient.dll (64bit dll).
  • DB account: Read_only (use this read-only account to avoid data loss).  The password will be created by OP.
  • Test the connection before you save the connection by pressing the OK button.

You can now use the ODBC connection with all ODBC enabled applications.

Note: If you need Office Practicum Support to configure the ODBC connection, charges will apply.