Error calling GetTables

I'm sure someone else will have come across this.
Dreamweaver MX2004

Creating a recordset as normal using DSN-less connection which has been working fine up until now suddenly reports Error calling GetTables when trying to view tables.

Have tried several things so far:–

Installed Win XP SP2 extension
Removed connection strings
Created new connection strings
Created new site
Changed hosting server (this is a remote server at an ISP)

The site still performs as intended when browsing.
Testing connections reports Connection was made successfully.

Can anyone shed some light on this ???

Many thanks

John H