Microsoft Query not working in V28

Question

I recently updated from V27 to V28 but for some reason when I try to update the Microsoft Query on my Excel files it comes up with the following error: 
 
 "Cannot find all files in data path. Driver's SQLSetConnectAttr failed. The driver returned invalid (or failed to retur) SQL_DRIVER_ODBC_VER: 28.0" 
 
 I have updated the ODBC file but I'm still getting this message. Any ideas on what to do?

Darron Cockram · Accepted Answer

Steve Tipple said: Cannot find all files in data path 
 This is the specific problem. Whatever datapath you have your DSN connection configured to use in Excel does not contain all of the expected DTA files. The default path that is used for the v28 DSN will be C:\ProgramData\Sage\Accounts\2022\company.000\ACCDATA. However if you previously used v27, upgraded to v28 and converted your data, the data will likely still be in the v27 default folder C:\ProgramData\Sage\Accounts\2021\company.000\ACCDATA. Assuming this is the case you have 3 options. 
 1. Move the data from the v27 to the v28 path (e.g. a backup/restore from within the application) or just move it on disk and reconnect in the main application). 
 2. Edit the DSN in ODBC Data Source Administrator (a tool that is part of Windows rather than a Sage specific thing) and change the default path for the v28 driver to be the old, existing location of your data. 
 3. Create a new DSN in ODBC Data Source Administrator, set it's data path to be the old, existing location of your data, and change your connection in Excel to use this DSN instead of the default v28 one.

Sage 50 Accounts

Microsoft Query not working in V28

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING