Data Replication 2
Results 1 to 3 of 3

Thread: Mysql Connection Error : No valid MySQL ODBC 5.x Unicode Driver is installed.

  1. #1
    Layeeq is offline Junior Member
    Join Date
    Nov 2018
    Posts
    8
    Rep Power
    0

    Mysql Connection Error : No valid MySQL ODBC 5.x Unicode Driver is installed.

    Hi Team,

    I am getting below error after installing driver also , not able to connect to mysql.

    No valid MySQL ODBC 5.x Unicode Driver is installed. The required ODBC driver or driver manager is not properly installed and configured.

    I installed Attunity Express Edition trail verison 6.2 for one month.

    ODBC Driver:
    mysql-connector-odbc-5.3.10-1.el7.x86_64

    Mysql version : 5.6.41 MySQL Community Server (GPL)
    Linux x86_64

    i installed Attunity replicate Express edition trail version 6.2 in Linux Machine.

    I re-start replicate after mysql ODBC driver installed.I added LD_LIBRARY entries new path as well.

    But still getting same error.

    Please help me on this.


    I am doing CDC from MYSQL to Hadoop.

    Please find attached screen.

    Please help me on this, Thanks.
    Attached Images Attached Images  

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    301
    Rep Power
    6
    1. check the user guide on MySQL configuration for the Linux

    2. has the right path to the driver has been specified in the odbcinst.ini.

    3. check that /usr/lib64/libmyodbc5w.so exists and if not change the odbcini variable to the correct one. ,,, if the file exists, does the user used for Replicate have access to this file?

    4. if all above is set correctly, try:
    on the source endpoint, advanced tab / internal parameter - in the search. type in "provider" omitting the quote.
    then ,, set provider = MySQL ODBC 5.2.6 Unicode Driver.

  3. #3
    Layeeq is offline Junior Member
    Join Date
    Nov 2018
    Posts
    8
    Rep Power
    0

    No valid MySQL ODBC 5.x Unicode Driver is installed. The required ODBC driver or driv

    Hi,

    I have check as i have gone through MYSQL Configuration Docs. but still the same issue.

    Please help, if i have to check any other things.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •