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.
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.
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.
*Community Hub is the new name for Sage City