topic Re: ODBC driver not found when connecting to MySQL in Qlik Replicate

ODBC driver not found when connecting to MySQL

caifeng123 — Thu, 02 Nov 2023 15:15:28 GMT

Hi, I am running Qlik Replicate on windows.

I follow the link to download and install the driver and I verified that it is there.

https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/AWS%20RDS%20MySQL/aws_prereq_mysql.htm#:~:text=Make%20sure%20that%20the%20/etc/odbcinst.ini%20file%20contains%20an%20entry%20for%20MySQL%2C%20as%20in%20the%20following%20example%3A

But when I try to create a source endpoint, it complains driver is not installed. The setup has a lot of instruction for Linux, but for windows, it just say install the driver.

Driver prerequisites

Replicate on Windows

Install MySQL ODBC Unicode Driver 64-bit version 8.0.32 on the Replicate machine.

This is the error I am getting:

Re: ODBC driver not found when connecting to MySQL

Dana_Baldwin — Thu, 02 Nov 2023 15:46:52 GMT

Hi @caifeng123

The Replicate server service needs to be restarted after drivers are installed before they are recognized. Might be advisable to reboot the server. Please try this as a next step.

Thanks,

Dana

Re: ODBC driver not found when connecting to MySQL

caifeng123 — Thu, 02 Nov 2023 15:49:29 GMT

I did all reboot and stuff.

I figured it out, it need the exact 8.0.32 version of ODBC driver.
I installed 8.2 version.

Re: ODBC driver not found when connecting to MySQL

SushilKumar — Fri, 03 Nov 2023 07:15:10 GMT

Hello team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,

Sushil Kumar