Welcome to the Sage 50 Accounts UKI Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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
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…
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…
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…
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…
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 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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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,…
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…
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…
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…