We are currently updating the OP Help Center content for the release of OP 14.19 or OP 19. OP 19 is a member of the certified OP 14 family of products (official version is 14.19.1), which you may see in your software (such as in Help > About) and in the Help Center tabs labeled 14.19. You may also notice that the version number in content and videos may not match the version of your software, and some procedural content may not match the workflow in your software. We appreciate your patience and understanding as we make these enhancements.

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.