FormerMember

ODBC (64 bit) connection to new 50c 2020.0 with Actian Zen v13 database

SUGGESTED
Posted By FormerMember

After Upgrade to 50c 2020.0 with Actian Zen v13 database where  can I find an ODBC (64bit) Driver to connect directly to the database?

I can connect with the ODBC (32 bit) but it will not function with Microsoft Access 64 bit.

  • 0
    SUGGESTED

    Ahh the pipe dream access to your data...  I keep hoping for something that is read and write enabled.  It is never to be with Sage 50 it seems.

    For read access try this: c:\windows\SysWOW64\odbcad32.exe and add your 32 bit connect there.  I do it all the time so I can build my own reporting and utilities to at least find issues.  Also, after the upgrade you have to re-enable ODBC connectivity in Sage.