Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BillyWhizz
Starting Member
6 Posts |
 Posted - 2001-11-05 : 10:30:00
|
| I cannot do a Bulk Insert over the local network. The same file is imported correctly when copied to the SQL Server and Bulk Insert is run on the local file, but in real life I will be importing data from temporary files generated by an ASP script, so the Bulk Insert MUST happen over the network.Instead I get this error;'Could not bulk insert because file '\\WEB1\d$\tempAnswerFiles\testFile.log' could not be opened. Operating system error code 5(Access is denied.).'I have made the permisiions as loose as possible on this directory, it is where users upload their photos for display on website.I am using IIS5 and SQL Server 7 (both patched and Service Packed right up to date) on separate machines. They talk to each other all the time with no problems. Why, oh why am I getting this error? |
|
|
|
|
|
Bulk insert - permissions