Constraint Violating Yak Guru
Posted - 09/13/2004 : 14:00:49
I'm using ASP Classic app has the following pieces:
-- form: Loads a list of text files into a listbox using FileSystemObject
-- form: user choose various options from other listboxes
-- ASP "action" script: sends choices to SQL Server 7.0 SPROC
-- sproc does a BULK INSERT with text file data and eventually updates another SQL table
-- once SQL table update completed, FSO runs again to move the successfully-processed text file to a "completed" directory.
The only way I can get the app to work is if I give full permissions to the shared directories that hold the text files to the local Administrators group (WIN 2K running IIS 5). If I remove local Admins group from permissions list, leaving my normal logon (which is in a different domain, but still has full permissions to these shares), I get the following error:
"Could not bulk insert because file '\\servername\sharename\filename.txt' could not be opened. Operating system error code 5(Access is denied.)."
My shares are not on C$, they are on D$ (NTFS). This app is in testing and I want to roll it out to regular users. Any ideas what's going on? Is it possible that FSO can only be used successfully by Local Administrators?