Hello Malik,
The related ODBC error is usually thrown when on target machine is not installed the ODBC driver you are specifying in your SQL Connection parameters (Driver=[\{]MySQL ODBC 5.3 Driver[\}]

. Can you please make sure the "MySQL ODBC 5.3 Driver" (32-bit architecture) is installed on target machine. In order to check this you can simply run the "C:\Windows\System32\odbcad32.exe" file (on 32-bit machines) and check your currently installed drivers from "Drivers" tab. On 64-bit machines you should run the "C:\Windows\SysWOW64\odbcad32.exe" file in order to check the 32-bit installed drivers.
Also, checking the "SqlConnectionString" property set into your sent project, I've observed that you have added a space character after the
Driver=[\{]MySQL ODBC 5.3 Driver[\}] ; parameter. Can you please remove it (just before semicolon -
Driver=[\{]MySQL ODBC 5.3 Driver[\}];) and see if the behavior still persists? Just go to "SQLConnectionDlg" dialog, select the [Next>] button and edit the existing "Set installer property value" published event to like this:
- Property: [SqlConnectionString]
Argument: Driver=[\{]MySQL ODBC 5.3 Driver[\}];Server=[SERVER_PROP];Port=[PORT_PROP];Uid=[USERNAME_PROP];Pwd=[PASSWORD_PROP];
Let us know if this helped.
All the best,
Daniel
FOLLOW US
Get the latest news in Application Packaging