Error -2147206396 – Not Supported

When working with a MySQL database using an older ODBC 5.2 driver, a message similar to the following appears when attempting to print a report or form:

report was NOT displayed successfully

due to the following error: -2147206396 – Not Supported

While AYS itself will work with early versions of the MySQL ODBC 5.2 driver (Connector), the packaged Crystal Reports viewer is incompatible, and displays the above error when trying to print anything from the application.

Delete the v5.2 driver DSN connections and uninstall the driver from your system, and download one of the following ODBC connectors for MySQL and create a new DSN connection.

  • 5.1.x
  • 5.2.7 or greater
  • 5.3.4 or greater