>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