x Want to participate? Join the group to interact

  • Error pulling data in SSIS from ODBC connection

    Hi, I am trying to pull the data from sage into sql server using ssis. However I am receiving the following error I have set my ODBC connections up as And the SQL server setup is Can anyone help? Thanks Chris

  • Custom program cannot connect to Sage 50 after upgrade from v25 to v26

    Hi all, I have a customer that have been using Sage 50 and my custom program for few years and its working perfectly. Until recently the customer upgrade from v25 to v26, now my custom program is not working because of connection problem. The error…

  • Subqueries in ODBC connection

    Hi, Is it possible to do subqueries when connecting to Sage 50 via ODBC connection? I would like to do something like: SELECT AUDIT_HEADER.INV_REF, AUDIT_HEADER.DETAILS, AUDIT_HEADER.DATE, AUDIT_HEADER.DUE_DATE, AUDIT_HEADER.NET_AMOUNT, USAGE.AMOUNT…

*Community Hub is the new name for Sage City