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 2 ODBC driver managers:
In case when 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.
To install the driver, you should download the archive containing installation files, unpack and run installation with root privileges. See the detailed description of these steps below:
tar -xf devartodbcsqlserver-linux.tar
To add/update the sqlserver.lic file to an already installed driver, you need to create/replace this file in the directory with the installed driver, and save the new activation key to it.
Driver is installed successfully.
After the driver is installed, two DSNs with the names DEVART_SQLSERVER_X64 and DEVART_SQLSERVER_X86 are created. You can use them to test connection with SQLSERVER server, we will use DEVART_SQLSERVER_X86 as an example. Now perform the following steps:
User ID=<your SQL Server User Name> Password=<your SQL Server password> Server=<your SQL Server server address> Port=<your SQL Server Port> Database=<your SQL Server database name>
isql -v DEVART_SQLSERVER_X86