The content of this blog has moved to a new page because this website now uses
.NET framework master pages. You should be redirected automatically. The content below is just for search engines
and others who have linked to the original page before we updated the website.
C7 Solutions Team Blog
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).
# posted by Brian Reid : 1:29 PM
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