ODBC Driver for SQL Azure 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 Azure is compatible with 2 ODBC driver managers:
In case when using other ODBC driver managers, ODBC Driver for SQL Azure 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 devartodbcsqlazure-linux.tar
To add/update the sqlazure.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_SQLAZURE_X64 and DEVART_SQLAZURE_X86 are created. You can use them to test connection with SQLAZURE server, we will use DEVART_SQLAZURE_X86 as an example. Now perform the following steps:
User ID=<your SQL Azure User Name> Password=<your SQL Azure password> Server=<your SQL Azure server address> Port=<your SQL Azure Port> Database=<your SQL Azure database name>
isql -v DEVART_SQLAZURE_X86