Skip to content

Knowledge Base

Business Process Automation Platform

SAGE 50 Accounts 2012 – ODBC query fails with “DAO error column not found ODBC — call failed”


When you query data within the Database Query (ODBC) tool you may receive the following error:

DAO error column not found ODBC -- call failed


The error is due to changes that have been made to the “Sage 50 v18 ODBC driver” in Sage 50 Accounts 2012 update 3. The change causes queries that make use of Data Access Objects to fail.

Applies To

TaskCentre: all versions where a task with an ODBC step connects to the “Sage 50 v18 ODBC driver” that ships with Sage 50 Accounts 2012 update 3.


Data Access Objects (DAO) is a data access library that ships with Windows. It provides additional functionality for ODBC drivers. For example, allowing the use of a current date function in an ODBC query where the ODBC driver does not natively support this.

Within TaskCentre you can make use of DAO by deselecting the “use pass-through” option under the connection tab of the connection’s global configuration.


An ODBC hotfix has been supplied by Sage that resolves this issue. At the time of writing this can be accessed by logging in to, selecting the “Downloads Home” page and downloading the “Sage 50 Accounts 2012 – ODBC Hotfix”.

Sage 50 Integration Brochure

Sage 50 Integration Brochure

Learn how integrating Sage 50 with on-premises or cloud-based business software removes the risk of costly errors and improves the visibility of critical data.