"MikeD" <MikeD@discussions.microsoft.com> wrote in message
news:C294663B-2AE3-4E19-B1D4-23180C853A9A@microsoft.com...
> Hi,
>
> I'm accessing a FoxPro database via ole db and ths works fine on my local
> report server. However, when I deploy the report to the live report server
> I'm getting the error 'Invalid path or file name'
>
> The FoxPro database is on a separate server and the connection string is :
> string connectionString = @"provider=vfpoledb;" +
> @"data source='\\server\data\foxpro.dbc';" +
> "password='';user id=''";
>
> I've read a few articles explaining that it's a permissions problem. I've
> tried granting full permissions to the data folder for myself and 'Network
> Service' but this still occurs. The web.config file for the report server
> has
> impersonate set to true and IIS is configured for 'Integrated Windows
> authentication' and does not use anonymous access.
>
> Any ideas would be much appreciated.
>
> Regards
>
> Mike