Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
RajuD
Partner - Contributor
Partner - Contributor
‎2023-09-04 03:34 AM

MySQL endpoint: Cannot connect to ODBC provider

Hello,

 

I was trying to connect with MySQL as source endpoint but unfortunately i was ending up with this error.

 

  • SYS-E-HTTPFAIL, Cannot connect to ODBC provider.
  • SYS,GENERAL_EXCEPTION,Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: HY000 NativeError: 2003 Message: [MySQL][ODBC 8.0(w) Driver]Can't connect to MySQL server on '13.200.86.168:3306' (10060)
Labels (2)
Preview file
130 KB
832 Views
0 Likes
1 Reply
OritA
Support
Support
‎2023-09-04 03:48 AM

Hi, 

When working with MySQL you first have to make sure that the FW rule of the requested connection allow it. You can check it ourside of Replicate from the computer where Replicate server is running. In addition, for every Replicate version, the User Guide indicates the ODBC driver version that needs to be used. Plese check this as well.  If problem still persits please open a case and provide the task diagnostic package for further troubleshooting. 

 

Thanks & regards,

Orit

 

825 Views