ODBC Driver for Firebird

Installing on Linux (RPM) - ODBC Driver for Firebird

Prerequisites

ODBC Driver for Firebird works under control of an ODBC driver manager. ODBC driver manager is not distributed along with our driver and must be installed separately.

ODBC Driver for Firebird is compatible with UnixODBC driver manager.

In case when using other ODBC driver managers, ODBC Driver for Firebird will be installed, but it will require manual modification of configuration files of these managers.

Installation

Let's consider how to install the Devart ODBC driver on Linux from an RPM package, for example, on CentOS. To install the driver, you should download the .rpm package and install it via the command line. See the detailed description of these steps below:

  1. Download the RPM package from the Devart website.

    By default the required package will be downloaded into the ~/Downloads folder (or the selected one);

  2. Run the 'Konsole' program;
  3. Navigate to the folder with the downloaded package cd ~/Downloads (if you downloaded the package into another folder, you need to specify the path to this folder as the cd command parameter):
    cd ~/Downloads/

  4. Use the following command to install the devart-odbc-firebird.i386.rpm on a 32-bit system:
    sudo rpm -ivh devart-odbc-firebird.i386.rpm

    Use the following command to install the devart-odbc-firebird.x86_64.rpm on a 64-bit system:
    sudo rpm -ivh devart-odbc-firebird.x86_64.rpm

  5. Driver is installed successfully.

To activate the driver, perform the steps described in the Product Activation article.



Test connection

After the driver is installed, a DSN with the name DEVART_FIREBIRD is created. You can use it to test connection with FIREBIRD server. For this, perform the following steps:

  1. Open the odbc.ini file located in the /etc folder. Find the DEVART_FIREBIRD section and specify the required connection settings:
    User ID=<your Firebird User Name>
    Password=<your Firebird password>
    Server=<your Firebird server address>
    Port=<your Firebird Port>
    Database=<your Firebird database name>
    Client Library=<path to the used Firebird  client library>
    
  2. Run the UnixODBC Test Command utility and test a connection using the following command:
    isql -v DEVART_FIREBIRD 

See also:

© 2015-2021 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback