Installing on Linux (RPM) - ODBC Driver for MySQL
ODBC Driver for MySQL 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 MySQL is compatible with UnixODBC driver manager.
In case when using other ODBC driver managers, ODBC Driver for MySQL 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 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:
By default the required package will be downloaded into the ~/Downloads folder (or the selected one);
sudo rpm -ivh devart-odbc-mysql.i386.rpm
Use the following command to install the devart-odbc-mysql.x86_64.rpm on a 64-bit system:
sudo rpm -ivh devart-odbc-mysql.x86_64.rpm
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_MYSQL is created. You can use it to test connection with MYSQL server. For this, perform the following steps:
User ID=<your MySQL User Name> Password=<your MySQL password> Server=<your MySQL server address> Port=<your MySQL Port> Database=<your MySQL database name>
isql -v DEVART_MYSQL