It looks like permission problem and I'm pretty sure it is. Are you using linked server to access VFP tables?
BTW, you tried MS JET ODBC driver not VFP ODBC driver.


>I am using the latest Oledb drivers from within Sharepoint and SQL Server 2005 to read/write to DBFs. This works fine when the dbfs are on the same server but doesn't work at all when the dbfs are on a different server (in the same domain.) From within the same application I can access non-dbf tables and files on any server in the domain so I don't think it's a permissions problem and I've uninstalled the antivirus/firewall to test that but I still cannot access the dbfs across servers. I've tried using the ODBC VFP drivers as well with not luck across servers. Has any one come across this problem?
>
>The error is:
>Connection not opened, Error: Invalid path or file name.
> System.Data.OleDb.OleDbException: Invalid path or file name.
>
>I've tried the complete UNC path AND mapping the drive and using drive letters. Same error message. I do get a slightly different error message when using the ODBC dBase driver with this connection string: Driver={Microsoft dBase Driver (*.dbf)};datasource=\\sgisqldev\data\abd
>The error is:
>Connection not opened, Error: ERROR [42S02] [Microsoft][ODBC dBase Driver] The Microsoft Jet database engine could not find the object 'clt.dbf'. Make sure the object exists and that you spell its name and the path name correctly.
>
>Thanks,
>