C7 Solutions Team Blog

Wednesday, May 07, 2008

Sage ODBC Error "cannot find all files in data path"

Saw this error when attempting to connect Excel/Microsoft Query to an installation of Sage when Sage v14 had been installed on Vista with Office 2007 (but these two programs are unrelated to the error).

If in Microsoft Query I select the listed data source for Sage then it would generate the above error. The problem was that the data source that is created by default points to the sample Sage database and not the database on the network that the company was using.

So to fix, create a new datasource and for the data path value enter the full URL to the Sage database including the ACCDATA folder (for example \\server\sage\company.000\accdata).

permalink posted by Brian Reid : 1:29 PM 0 comments

Archive

March 2005 July 2005 February 2006 May 2006 November 2006 March 2007 May 2007 June 2007 August 2007 April 2008 May 2008 June 2008 September 2008 October 2008 November 2008 January 2009 February 2009 March 2009