ODBC Error when try connect using MySQL Enterprise connector on Azure.

[MigueldelCampo]

Hello forum, how are you? We made a connection from Qliksense (not Cloud) to a connection in Azure, which has a MySQL Server Enterprise. The connection is established correctly, but when we try to retrieve data from the table in the configured schema, we encounter this error Unable to execute SQLTables....

Any suggestions?

[John_Sathya]

find some posts discussing the similar error, such as:

https://stackoverflow.com/questions/36829911/how-to-resolve-order-by-clause-is-not-in-select-list-ca...

https://blog.51cto.com/phpme/2443158

Note: this is for reference only and you will need to have database administrator to validate the change.