Installing on Linux (DEB) - ODBC Driver for PostgreSQL
ODBC Driver for PostgreSQL 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 PostgreSQL is compatible with UnixODBC driver manager.
In case when using other ODBC driver managers, ODBC Driver for PostgreSQL will be installed, but it will require manual modification of configuration files of these managers.
Let's consider how to install the Devart ODBC driver on Linux from a DEB package, for example, on Ubuntu. There are two ways to install the driver either manually or via the command line.
By default the required package will be downloaded into the ~/Downloads folder (or the selected one);
sudo dpkg -i devartodbcpostgresql_i386.deb
To install the devartodbcpostgresql_amd64.deb on a 64-bit system, use the following command:
sudo dpkg -i devartodbcpostgresql_amd64.deb
Driver is installed successfully.
To activate the driver, perform the steps described in the Product Activation article.
After the driver is installed, a DSN with the name DEVART_POSTGRESQL is created. You can use it to test connection with POSTGRESQL server. For this, perform the following steps:
User ID=<your PostgreSQL User Name> Password=<your PostgreSQL password> Host=<your PostgreSQL Server Name> Port=<your PostgreSQL Port> Database=<your PostgreSQL database name>
isql -v DEVART_POSTGRESQL