AnsweredAssumed Answered

Sage 50 Accounts ODBC Error

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

Hi,

 

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. http://www.filemaker.co.uk/solutions/customers/stories/unicol-engineering-manufacturing-database/ ) 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.jpg

 

 

ODBC Error: Cannot find all files in data path

The driver returned invalid (or failed to return)

SQL_DRIVER_ODBC_VER: 18.0

[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.

 

 

SOFTWARE DETAILS:

Windows Server 2008 R2 Standard (64-Bit)

FileMaker Server Advanced 11 / FileMaker Pro 11v3

Sage 50 Accounts Professional 2012 (18.0.10.208)

Sage ODBC Line 50 v 18

 

Thanks.

Outcomes