2. ASPRunnerPro General questions
  3. Operation must use an updateable query.
This topic is locked

Operation must use an updateable query.

 		2/15/2006 7:41:51 PM
ASPRunnerPro General questions
T
 theresafer author

Hi, I've never worked with ASP before so bear with me....I'm getting that error about permissions, and am running IIS on my local WinXP Pro machine for testing. I have changed the settings on the db directory and am still getting this error. The directory db is located in the C:\inetpub\wwwroot directory. Is this the correct location? If I need to modify the config string where is it located?
Thanks!

Theresa
T
 		theresafer author 2/15/2006

Well I managed to solve the problem by going back over the permissions, and made sure that all the files had the same permissions.
C
 		clig 2/23/2006

Well I managed to solve the problem by going back over the permissions, and made sure that all the files had the same permissions.


XP defaults to read only just copying a folder to the inetpub dir - just another annoying point added to the endless list
xcacls c:\inetpub\wwwroot\foo\. /T /G everyone:F /Y add this to an install script or something...
xcacls is a free resource kit tool available @ MSFT...
Sarjent 2/23/2006

XP defaults to read only just copying a folder to the inetpub dir - just another annoying point added to the endless list


Because in reality, you don't want write access to the inetpub folder for security...Ideally you setup a virtual path to the DB and reference that in your connection strings. Store the DB in the virtual path which is outside of the inetpub folder. This way you isolate your web and your DB.
C
 		clig 2/23/2006



Because in reality, you don't want write access to the inetpub folder for security...Ideally you setup a virtual path to the DB and reference that in your connection strings. Store the DB in the virtual path which is outside of the inetpub folder. This way you isolate your web and your DB.


Rightfully so - If you are of the mind to host a site in XP for anything other than local dev...