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