I was running the 180 day trial version of SQL Server 2005 Reporting Services on a server that also housed a Visual FoxPro table. The server is running Windows Server 2003.
We liked the product enough that we purchased a new server just to house the SQL Server 2005 and SRS.
When I moved all of the reports to the new server I am having trouble with all the reports that want to access FoxPro tables on another server. All the SQL Server based reports work fine.
The error I am receiving is:
"Query Execution failed for data set 'Departments'. (rsErrorExecutingCommand) Cannot open file \\IT-App\AppTrack$\Data\Department.dbf"
I am using the VFP OLE-DB Provider and the report works perfectly in the test environment and on the old test server. However, running the SRS on one maching accessing a VFP data source using OLE-DB on another maching is not working.
Any ideas or suggestions would be very appreciated.