1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • Re: Linking to Access from Excel - Test Connection failed because of an

    From Roger Zouhar@21:1/5 to aiiro on Tue Mar 21 12:54:39 2023
    On Monday, October 5, 2015 at 2:43:14 AM UTC-7, aiiro wrote:
    There is an undocumented "feature" in Windows (thanks MS!). This concerns of using 32-bit vs 64-bit drivers for ODBC. At least that was the case for me. I installed 64-bit MYSQL ODBC drivers since my Win7 is 64-bit and got the same error from Excel,
    since my Excel is 32-bit. So I finally figured it out, installed the 32-bit MYSQL ODBC drivers and voila, everything worked properly.

    Have fun.

    Aiiro has the correct solution. This is what solved it for me.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)