Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the google-analytics-dashboard-for-wp domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in C:\inetpub\vhosts\gck.org.uk\httpdocs\c7solutions\wp-includes\functions.php on line 6114
Sage ODBC Error “cannot find all files in data path” – Brian Reid – Microsoft 365 Subject Matter Expert

Brian Reid – Microsoft 365 Subject Matter Expert

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

in

by

Brian Reid

Tags:

Comments

One response to “Sage ODBC Error “cannot find all files in data path””

  1. Richard avatar
    Richard

    Thanks for putting this up, saved me some time.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.