Connecting to FoxPro database via OleDB in Reporting Services

G

Guest

Hi,

I'm accessing a FoxPro database via ole db and this 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
 
P

Paul Clement

¤ Hi,
¤
¤ I'm accessing a FoxPro database via ole db and this 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.

If the FoxPro file is on a different machine, it sounds like a security delegation problem. See if
the following helps:

http://msdn.microsoft.com/library/d...y/en-us/vsent7/html/vxconaspnetdelegation.asp


Paul
~~~~
Microsoft MVP (Visual Basic)
 
C

Cindy Winegarden

Hi Mike,

Does the report server's account have permissions to the directory?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invalid path or file name 1
SQL syntax problem with oledb provider for Visual FoxPro 1
FoxPro OleDb Problem on Windows 2003 1
Problem accessing FoxPro database across shared network 3
A much more specific ASP.Net/FoxPro problem 4
Connecting to FoxPro from .NET 8
Exception when accesing remotely VFP by using ODBC .NET provider. 4
"CREATE DATABASE permission denied in database 'master'. Could not attach file..." 3

Top