Problem connection to FoxPro database via ole db

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
MikeHi Mike,
Does the report server's account have permissions to the directory?
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
"MikeD" <MikeD@.discussions.microsoft.com> wrote in message
news:9A295512-41F7-48A0-B406-08AE86F55CA8@.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