MySQL.

For a Windows connection, the appropriate database driver for Windows can be downloaded from:
http://dev.mysql.com/downloads/connector.
For a Unix/Linux connection there are three main stages needed. These are:

  1. Install the iODBC driver manager
  2. Install the MySQL ODBC driver
  3. Set up the DSNThe iODBC driver manger for Unix/Linux platforms can be downloaded from:http://www.iodbc.orgby following the “downloads, cvs” link.The MySQL ODBC driver can be downloaded from:
    http://dev.mysql.com/
    and following the ‘MySQL Connector/ODBC’ link in the Downloads & Documentation list.

    MySQL Windows Connection

    For a standard Windows environment, select the Connector/ODBC link. On the next page select the Windows Downloads “Driver Installer (EXE)” mirror site link to download from.
    Windows already includes an ODBC driver manager, so this does not need to be installed separately.

    1. From the Windows Start menu select the Run option, browse for the downloaded file “MyODBC-standard-9.99.9-win.exe” (where 9.99.9 is the version number), and run it.
    2. In the MyODBC Installation Wizard window, click the Next button.
    3. Read the License Agreement, and if you agree to its terms, select the “I accept the license agreement” radio button, and click the Next key.
    4. In the Readme Information window, click the Next button.
    5. In the Ready to Install the Application window, click the Next button. The installation process will begin. This should take about ten seconds to complete.
    6. When the installation is complete, click the Finish button.

    MySQL Unix/Linux Connection

    Installing the iODBC Driver Manager

    The iODBC Driver Manager can be downloaded as an rpm file, or for older platform versions, a tar.gz file. You will need to build the driver manager. Download the appropriate file and copy it to your /usr directory. If you have a tar.gz file follow steps 1 to 3 and then continue at step 5, for an rpm file start at step 4.

    1. With the downloaded file in the /usr directory, unzip the file with the command: gunzip libiodbc-3.51.1.tar.gz
    2. Extract the files with the command: tar xvf libiodbc-3.51.1..tar
    3. Change directory to the newly created installation directory with the command: cd iodbc-3.51.1.
    4. For an rpm file, run the command: rpm –i file_name
    5. In the new directory run the command: ./configure
      The system will carry out a series of configuration functions.
    6. Run the command: make
    7. Run the command: make install

    Installing the MySQL ODBC Driver

    The MySQL ODBC driver can be downloaded as an rpm file or a tar.gz file.
    Download the appropriate file and copy it to your /usr directory. If you have a .tar.gz file follow steps 1 to 3 and then continue at step 5, for a .rpm file start at step 4.

    1. With the downloaded file in the /usr directory, unzip the file with the command: gunzip MyODBC-3.51.09.tar.gz
    2. Extract the files with the command: tar xvf MyODBC-3.51.09.tar
    3. Change directory to the newly created installation directory with the command: cd MyODBC-3.51.09
    4. For a .rpm file, run the command: rpm –i file_name
    5. In the new directory run the command: ./configure
      The system will carry out a series of configuration functions.
      Run the command: make
    6. Run the command: make install
      This process has not been successfully completed by Querix and is thus untested.

Click the link below to see
all KB articles by product.