Connecting to ODBC

New to Alteryx, and using Alteryx Designer 20231.1 Desktop.

When I try to connect to MySQL ODBC I get the error message below. I tried a workaround I found using ODBC 32 (instead of 64-bit), but I was unable to create a connection because it requires a 64-bit ODBC connection for MySQL. So, I'm scratching my head. Is this an Alteryx issue? I ask because I tried connecting to Google Drive and when I run a simple input with a Browse Alteryx keeps crashing.

Should I be using the cloud version or something and stay away from Desktop? I tired using that during the trial period, but it didn't seem to have all the same options.

Thanks for the help, and apologies if my issues are new user basic ones.

Michael

s Screenshot 2023-08-25 175736.png

Error Message

Accepted answers

apathetichell

Your mac is running on an ARM Mac chip - correct? I do not believe that it supports ODBC connections from Parallels - or if it does the nuance is something which I haven't really mastered. Either way - I would flag this as a driver/Parallels/Mac issue and reach out to MySQL.

Here's more informatoin on this:

https://forum.parallels.com/threads/mysql-connector-odbc-for-win-11-arm.356741/

All comments

geraldo

@mpp_michael

did you try to create the 64bit driver as User instead of System DSN? By the print you are installing as System are you on the server?

apathetichell

https://learn.microsoft.com/en-us/answers/questions/1059343/odbc-64-bit-error-193

Driver installed at the wrong level. I'd unintall both - and reinstall an older version of the 64. Prior to reinstalling I'd check if regsitry cleared out.

two other things - test/troubleshoot your odbc connection in odbc 64 prior to connecting in Alteryx - and just to confirm - you are running on a Windows PC - not a Mac running parallels?

mpp_michael

Thank you both for the helpful advice.

Geraldo: I tried creating/configuring from both user and system, cannot do it for anything (MySQL, Excel, etc.)

apathetichell: I tried as you suggested - I uninstalled all ODBC drivers and reinstalled just 64 - a few older versions.

In fact, I am running Parallels on a Mac. Is that an issue? I'm able to run all kinds of other software without issue. Should I be considering something different because I'm using Parallels?

Here are my settings for Windows:

Edition Windows 11 Pro
Version 22H2
Installed on ‎2/‎13/‎2023
OS build 22621.2134
Experience Windows Feature Experience Pack 1000.22659.1000.0

Here are my registry settings:

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\ODBC\ODBCINST.INI\ODBC Drivers - VALUE NOT SET (no ODBC data sources)

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WowAA32Node\Microsoft\ODBC\ODBCINST.INI\ODBC Drivers- VALUE NOT SET (no ODBC data sources)

I searched for Simba and could not find the folder where I expected (HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Simba Athena). Could this be the issue - that the folder is is not being uploaded during install? If so, does someone have the file I can import or at least the settings? I'll admit, I'm not expert at regedit.

Thanks for your help!

apathetichell

Here's more informatoin on this:

https://forum.parallels.com/threads/mysql-connector-odbc-for-win-11-arm.356741/

mpp_michael

Thank you, that seems to be the issue.

jaredcoffin

Please refer to my article response MySQL Simba Driver for connection via Input Data tool in Alteryx 2025.1.

apathetichell

@jaredcoffin--- hey this question was specifically about 64 bit odbc driver support on parallels with an ARM chip... I don't think your article is relevant --- totally solid for 'normal' implementations of course.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703