MySQL ODBC Connection - ODBC test works, but input tool in Designer returns error

Question

Hi,

I am trying to connect Alteryx Designer to an external MySQL database using an ODBC connection. I have the ODBC set up, the ODBC tests just fine within the ODBC admin app, but when I try to drag in an input tool to the canvas, I get a "no columns returned" error every time, even on a simple query on a table that I know exists.

Can anyone shed any light here? I'm using MySQL Connector ODBC version 8.0.32.

Thank you!

mtren · Answer

Thanks for trying, but adding the database name to the query didn't help anything.

mtren · Answer

Hi, I'm not using in-DB connections- just trying to make use of a regular Input Tool.

Your comment intrigued me, though, because seeing tables listed but still getting a "no columns returned" error is exactly what's happening. Could you elaborate a bit more on what might cause this or how I might go about troubleshooting it?

Thanks a lot.

leefarrell · Answer

It sounds like you've set up the ODBC connection correctly, but Alteryx is having trouble retrieving columns. Here are a few steps to troubleshoot:

* Check Permissions: Ensure the user account you're using has the necessary permissions to read the tables in the database.
* Test Connection in Alteryx: Use the "Input Data" tool and manually enter the SQL query to see if the columns appear.
* ODBC Driver: Confirm that the ODBC driver version 8.0.32 is compatible with your MySQL server version.
* Driver Configuration: Revisit the ODBC Data Source Administrator and double-check all settings, particularly the database name.
* Alteryx Logs: Look at the Alteryx logs for more detailed error messages.