• 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
  • Cannot connect to Sage50cloud with ODBC and PHP PDO

    Hi, I have recently upgraded Sage50cloud Accounts to v28.1.404.0 from an earlier v28 installation and my ODBC Connection now fails from my PHP SOAP Server using PDO. The connection worked perfectly with the previous v28 and my ODBC Connection for…
  • ODBC link to Excel in current year before the ledgers are closed for the prior year

    Hi, I have the ODBC link set up to extract info from Sage for our monthly accounts, by month and nominal codes. We don't close our ledgers until our Stat accounts are completed so the ledger is still showing prior year. Is there a way I can change…
  • Supplier Turnover figures

    When running the report for supplier turnover, subcontractors who are nett and pay CIS tax, as it is a credit note automatically produced on your system, it is deducted from the turnover figure. We need subcontractor turnover figures to give to the…
  • 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…
  • Sage 50 Accounts ODBC query - transactions missing from audit split table

    I have a long standing (5 yrs plus) excel workbook which is an extract from the audit split table for a client via MSQuery/ODBC. The client is on V26. I noticed for the first time this morning that there is a large number of transactions missing from…
  • ODBC Error using MS Power Query (Office 365)

    ODBC Driver error in Power Query "Unexpected error: Attempted to read or write protected memory..." We are using the Sage 50 v25 32b ODBC driver. The underlying query is "select * from ACCOUNT_STATUS" or specifically when querying date time (tz sensitive…
  • Nominal Ledger Activity Data import into Microsoft Power BI

    Hi, I am a Business Intelligence Developer in my company and importing data from Sage 50 accounts database into Power BI using sage ODBC driver. Nominal Ledger table has data at month level but now, our requirement is data at the invoice level. There…
  • Empty Sage50 database table : Connection with Power Bi/Excel

    Hi, I am a business intelligence developer in my company, importing data from sage50 database into Microsoft Power bi right now. One specific table, Update_Ledger, is not showing any data and this is the main table for our reporting needs. Why is it…
  • ODBC Date Conversion

    Hi All, Hopefully someone has dealt with this issue before ODBC links are set up and usually work fine as lone as I don't use anything beyond SELECT, FROM, WHERE, AND, GROUP BY and ORDER BY However, I want to convert a date field to "MM-YY" for…
  • Upgrade Sage version - ODBC Compatibility

    We need to upgrade one off our clients to Sage 50 v25 from v23. However, their Access database has ODBC links to the current version. Does anybody here know about the ODBC connector? Specifically, when we upgrade, will the ODBC links still work, or does…
  • Sage Line 50 ODBC Connection issue

    I am getting the following error with the Sage Line 50 v23 32-bit Odbc driver: ERROR [08001] Cannot find all files in data path ERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 23.2 ERROR [IM006] [Microsoft][ODBC…
  • Error [IM003] System error 8 - when trying to print a report

    Dear All, I just wanted to share a solution that took me almost a month to solve, if you have come across this error, I would be very interested to hear how you have solved it. SAGE Support was unable to help, and had no knowledgebase notes on the…
  • 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…
  • Sage 50 V23 upgrade not working with MS Access via ODBC

    Good Afternoon I run a number of queries in MS Access with a connection to Sage 50. Since upgrading I cannot connect to Sage 50 any more. I've tried to select a new location for the tables using the new Sage50v23 DSN but it won't accept my user…
  • Sage V23 32 bit ODBC driver

    Where can i get the standalone 32 bit ODBC driver for Accounts V23?
  • Does anyone know how to resolve Error 126 when trying to connect to accdata via ODBC (using MS Access or Excel) since the Upgrade to Version 24

    I am no longer able to access the SAGE data using Excel (or MSAccess) since the machine hosting SAGE has updated to version 24. I have installed V24 on both PCs, i have installed the ODBC driver for V24 and amended the DSN to point at the correct location…
  • Batch update analysis fields on sales orders

    Hi, I need to update one of the analysis fields on many sales orders in Sage 50 Accounts Professional. These are highly repetitive and the task of inputting them manually would be inefficient. Since there is no way to do this through the interface,…
  • Sage Accounts V22 ODBC Driver

    Where can I get the ODBC driver for Sage Accounts v22? I have found the 32 bit driver for v23 on Ask Sage but the 32 bit driver for V22 is not on the web site. I could get the driver from our server with our instance of Sage Accounts on it if it wasn…
  • Insert a new record to Sage DB via ODBC connection

    Hi! Could you provide any information or URL - where I can see the working an example for insertion of a new record to Sage DB via ODBC connection? I can read the data easy but not update and insert. Or it is not possible at all? All my…
  • Accounts 50 v24 ODBC --call failed Access 97

    Hey We recently tried to upgrade to Accounts 50 v24 (from v22) and discovered that the ODBC driver call from Access 97 no longer seems to work. In every other upgrade I have gone to access tools, then linked table manger, and then select a 'new…