Operating system error code 3(The system cannot find the path ...)

[dougancil]

I have a page that I've built that does a bulk insert from a file that is stored on a web server. When the user clicks on the submit button, they receive the following error:

Operating system error code 3(The system cannot find the path specified.).

I have made sure that the SQL server has admin rights to the path of the folder that has the file uploaded to it (I even added the specific SQL server user to the admin rights) and it still won't work. The SQL server is 2000 and the web server is Windows Server 2003. Any ideas as to what may be causing this? I've read several different posts on several different forums and it seems that the consensus has been that it's a permissions issue. I think that with all that I've done, that the permissions are set up correctly but I may be wrong.

Thank you

Doug

 

[ca8msm]

I'd agree with the general consensus of it being a permissions issue. Who is actually doing the bulk insert? The web application or SQL Server? If it is your application, what authentication method are you using? Is there any impersonation in your site?

Mark,

Darlington Web Design[tab]|[tab]Experts, Information, Ideas & Knowledge[tab]|[tab]ASP.NET Tips & Tricks

 

[dougancil]

Mark,

You are right, it's not a permissions issue. I modified the machine.config file on the web server and impersonated the admin account to be able to work through this error and was confronted with another error about another line written within the .vb codebehind. That's my next issue. I'm going to close this thread and open one about that.