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

[mtren]

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!

[LindonB]

Hi there. Not sure where in the process you are. If you set up your ODBC connections, but don't see them listed in Alteryx, you need to also make sure the connections are set up in Alteryx. You mostly use the same information as you entered in ODBC. The configuration is found under Options > Advanced Options > Manage In-DB Connections. If you're seeing the tables listed but still getting errors, you'll want to make sure it's configured correctly; your DB admin should be able to help there.

[alexnajm]

Likely you need to add the database name to the query:  https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/ODBC-Connection-MySQL-input-da...

[leefarrell]

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:

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

[mtren]

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.

[mtren]

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