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