Connecting to ODBC

[mpp_michael]

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

[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 · Accepted solution]

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/

[mpp_michael]

Thank you, that seems to be the issue.