>>>>Hi,
>>>>The error message is:
>>>>
>>>>"Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>>>>
>>>>[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified "
>>>>
>>>>which indicates the system dsn name is incorrect.
>>>>
>>>>We have discovered by accident that by having Office2000 installed on the same server the error goes away! However, we do not want to have Office2000 on the server. I am assuming therefore that it must be something to do with ODBC drivers???
>>>>
>>>>Regards
>>>>BS
>>>
>>>Is this a system DSN on the server or are you using a connection string (DSN-less)?
>>>
>>>If it has something to do with the ODBC driver (this error not indicative) try downloading the latest version from the VFP page: http://msdn.microsoft.com/vfoxpro/downloads/odbc.asp
>>
>>
>>It is a system DSN on my ISP's server. I was assuming that I would not be able to set up a DSN-less connection on "another" server because of security restrictions.
>>
>>Likewise, I do not think I can persuade my ISP to download additional drivers.
>>
>>Regards
>>BS
>
>The one other thing I would check is if the IUSR_ account has read permissions on the free table directory the system DSN points to.

The data directory is a subdirectory of my main website and can accept files being uploaded to it. As the rest of the directories (eg images) can be read from I have assumed the data directory can be read as well. But I can always ask my ISP to check......