.Net Retrieving Data From Server - Permissions Issue

See more:

.NET

IIS

C#5.0

Hi,I am trying to read data from a server on our network using VFPOLEDB.1 however I am getting an error:

"Invalid path or file name"

which is caused by a permissions issue.

I have tried using the impersonate in web.config file and also set the application pool account in IIS to admin credentials but still getting the error.

This worked fine when I was debugging using my local machine as host but when debugging using IIS it gave me the error.

I have also tried to use my my own domain accounts in the IIS server 'mydomain\myaccount' but still doesnt work, it should work because I can access the server folder from my pc.

I have checked what account it is running under by using the below code and it is the correct account:

<%= System.Security.Principal.WindowsIdentity.GetCurrent().Name%>

//connection string I am using .
@"Provider=VFPOLEDB.1;Data Source=//Servername/Folder/Folder/Folder/VFP.DBC;Collating Sequence=MACHINE"

Can anyone point me in the right direction please?

Many thanks