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


Media Player 11 jumps or skips near end of songs

Finally fixed this one! On Windows Media Player 11, running on Vista on Dell hardware the sound-card (with a SigmaTel device) would ruin the end of every song, but sync the song to a mobile device or use a different media player (VLC for example) and the songs play the bit near the end fine.

The problem is the device and its interaction with Windows Media Player. For the device you need to disable the playback enhancements.

This is done from Control Panel > Sounds. Right-click the Speakers/Headphones entry and choose Properties. On the Enhancements tab select Disable all enhancements. I did not need to reboot or even restart Media Player as I have read reported.

virtualisation vista

Windows Vista on Virtual PC’s

As I do not have any spare PC hardware I decided to install a copy of Windows Vista (Beta 1) on virtualization software. I have a choice of both VMWare Workstation 5.0 and Microsoft Virtual PC.

And the winner is – Microsoft Virtual PC

The reason is simple – I can see what I am doing and what is happening with Virtual PC as it runs with a decent virtual graphics adapter. VMWare Workstation 5.0 runs at 4bit colour until after installation has completed and you install the VMWare tools (which installed fine) but compare that to Virtual PC and the experience is so different.