mysqlexcelodbc

Unable to connect via ODBC in Excel (while connection test works fine)


Since I don't like reading long questions myself I'll make it quick and dirty:

Starting Point:

Goal:

Problem:

!BUT! I can connect from other workstations just fine (same setup/credentials).

Checklist:

Steps taken in excel:

enter image description here

No further steps are taken within excel.

What else could I check? What am I missing here?


Solution

  • The error message shows that MySQL is receiving esa as the username. Double-check that your DSN does not have the wrong username value saved.

    I'm guessing that your Windows, Excel, and intended ODBC driver are all 64-bit.

    You might have a 32-bit User DSN that's getting in the way of a 64-bit User DSN; best to only use System DSNs on 64-bit Windows, as discussed here. Be sure to use both 32-bit and 64-bit ODBC Administrators (C:\Windows\SysWoW64\odbcad32.exe and C:\Windows\System32\odbcad32.exe, respectively) to check.