MySQL not working with ODBC connection in Sagent

Product Feature: Design Studio


 

Issue

MySQL does not work with ODBC connection.

Cause

Incorrect MySQL connector.

Resolution

UPDATED: September 5, 2017

Follow the steps:

  1. Download and install 64-bit connector version 5.2.
  2. run C:\WINDOWS\SysWOW64\odbcad32.exe.
  3. Set up DSN from scratch again.