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,