Invalid path or file name

[MikeD]

Hi,

I'm accessing a FoxPro database via ole db using Reporting Services Data
Extensions 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.

I also get the same problem when I've created a web service to access the
database so I assume it's a problem within IIS but I'm really struggling to
find out the exact problem.

Any ideas would be much appreciated.

Regards

Mike

[Craig Deelsnyder]

On Tue, 28 Mar 2006 08:51:02 -0600, MikeD
<Mi***@discussions.microsoft.com> wrote:

Hi,

I'm accessing a FoxPro database via ole db using Reporting Services Data
Extensions 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

There's a one hop rule in NTLM/authentication. Meaning you can use NTLM
to impersonate a user on the webserver (the one hop, from the user's
computer to your server), but the 'credentials' can't be passed to another
computer to impersonate the user on yet another machine. Workarounds are
either use of Kerberos(with forwarding) on the network, or grant access to
the database to the webserver's machine account, as this is the default
account in machine.config.

--
Craig
Microsoft MVP - ASP/ASP.NET