• Allow ODBC Connection to Reocurring Data

    Allow ODBC connection or connection via sage report designer to the table that holds the data of reocurring invoices, including frequency, value, start date, invoice item lines etc. This would allow us to audit the reocurring invoices setup in our software…
  • Remote access to Sage Remote Data via IP or ODBC Connection

    Hi, We have just migrated to Sage V28 hosted on our server within our head office, we run a business management system written in VB.NET that sits on remote PC's, in days gone by we have periodically copied data from sage into an identical data structure…
  • 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…
  • 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…