• ODBC Error when SSIS package is run from SQL Job - Sage 2022

    Hi All. We're in the process of upgrading to Sage 2022 and I'm trying to recreate some SSIS packages (SQL Server 2019 and Visual Studio 2022) that connect to Sage 2022 via the ODBC 64-bit driver and copies to one of our SQL Server 2019 tables. I'm…
  • Sage 100c 2016 Unified Login SQL Linked Server Issue

    We have a client that is having a very strange issue with ODBC drivers when we try to setup a linked server in SQL. No matter what we try we get an error that seems to suggest that the login is failing but ONLY when we try to access it from SQL. Using…
  • RE: 64 bit ODBC connection to MAS 4.5 installation

    Hi I try to connect Sage 2013 to SQL Server 2012-64x I have MAS 90 4.0 ODBC Driver 64x (Version 4.40.02.00, Date 9/28/2012) The DSN works well, Linked Server is Successfull but when i try to select from linked server i get this error: ( Sage2013x64…