ODBC Driver for SQL Server Installing on Linux (DEB) - ODBC Driver for SQL Server

Prerequisites

ODBC Driver for SQL Server 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 SQL Server is compatible with unixODBC driver manager. Depending on your Linux distribution, you can install the unixODBC driver manager using one of the following commands:

• For Ubuntu 23 and later versions:
  sudo apt-get install libodbcinst2 libodbc2 odbcinst unixodbc
• For other distributions, including Ubuntu 22 and earlier versions:
  sudo apt-get install odbcinst1debian2 libodbc1 odbcinst unixodbc

If you are using other ODBC driver managers, ODBC Driver for SQL Server will be installed, but it will require manual modification of configuration files of these managers.

Installation

Let's consider how to install Devart ODBC Driver on Linux from a DEB package, for example on Ubuntu. There are two ways to install the driver—manually using the GUI or via the command line.

GUI installation

1. Download the DEB package of the required bitness from the Devart website.
2. Navigate to the folder with the downloaded package ("Downloads" by default) and double-click it.
3. In the opened dialog, click Install.
   

If the installation is successfully completed, the Install button changes to Remove.

Command-line installation

1. Download the DEB package from the Devart website.

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

2. Run the 'Terminal' program.
3. Navigate to the folder with the downloaded package (if you downloaded the package to a folder other than ~/Downloads, specify the path to that folder as the cd command parameter):

   cd ~/Downloads/

   
4. To install the devartodbcsqlserver_i386.deb on a 32-bit system, use the following command:

   sudo dpkg -i devartodbcsqlserver_i386.deb

   

5. To install the devartodbcsqlserver_amd64.deb on a 64-bit system, use the following command:

   sudo dpkg -i devartodbcsqlserver_amd64.deb

   

The driver is installed successfully.

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

See also:

• Install Linux RPM package
• Installation on Windows
• Installation on macOS