AnsweredAssumed Answered

Sage 50 Accounts ODBC Error

Question asked by james.gould on Jan 31, 2012
Latest reply on Mar 21, 2012 by timwhisenant



We have built a project management solution for one of our clients, which includes recording the job costs and generating monthly invoices as PDFs. They would like us to develop a solution that lets them easily add the data from these invoices into their Sage Accounts.


I have seen that some FileMaker solutions (e.g. ) have used ODBC to interact with Sage - but I am yet to find anywhere that gives details regarding the configuration between FileMaker and Sage. I can't even find anywhere specifying version numbers!


I have setup the ODBC data source on the Server as a System DSN and tested it using Excel. However when I attempt to add it as a data source to FileMaker I receive the following error:





ODBC Error: Cannot find all files in data path

The driver returned invalid (or failed to return)


[Microsoft][ODBC Driver Manager] Driver's

SQL SetConnectAttr failed

[Microsoft][ODBC Driver Manager] The driver doesn't

support the version of ODBC behaviour that the

application requested (see SQLSetEnvAttr)



I would be very grateful if somebody knows a solution to this error? (e.g. I've configured it wrong) or can suggest/recommend an alternative solution for to integrate FileMaker with Sage.




Windows Server 2008 R2 Standard (64-Bit)

FileMaker Server Advanced 11 / FileMaker Pro 11v3

Sage 50 Accounts Professional 2012 (

Sage ODBC Line 50 v 18