Here's a new twist.
I can access 2 different servers and their databases (on a remote server in London) from my site no problems.
An other site (30 miles away) they have entered in the right file path and file name and get the message. 'Either the host is not available or the file is not available on that host.'
Interestingly they can access it no problem via WebDirect.