Classic ASP Discussion - Cannot update. Database or object is read

Print Page | Close Window

Cannot update. Database or object is read

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=6696
Printed Date: 31 March 2026 at 1:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Cannot update. Database or object is read

Posted By: brolinuk
Subject: Cannot update. Database or object is read
Date Posted: 24 October 2003 at 9:51pm

I tried to run the Asp program on my computer and got this error message when I trying to connect the program to the database. I think it might be some thing wrong with permissions on the server. However, I don't how to configure the permissions under Windows XP Pro. I wish any body could give me a hand. The IIS that used is version 5.1. Thanks

Replies:

Posted By: Flamewave
Date Posted: 25 October 2003 at 1:28am

Whats the error message? if its permission errors, then all you have to do is set the permissions for the IUSER_COMPUTERNAME by right-clicking on the database (or folder the db is in) and giving them the ability to view, read, and write to the database (if they aren't going to need write ability, you can not give them write access for extra security).

-------------
- Flamewave

They say the grass is greener on the other side, but if you really think about it, the grass is greener on both sides.

Posted By: KCWebMonkey
Date Posted: 25 October 2003 at 2:54pm

if it says that database or object is read only, then you need to set the IUSR acct permissions in the database folder to read and write.

Posted By: KCWebMonkey
Date Posted: 25 October 2003 at 2:55pm

http://www.webwiz.net/asp/faq/server_permissions.asp - setting up permissions.

Posted By: brolinuk
Date Posted: 26 October 2003 at 5:52pm

Thanks for your reply mates. The problem is that I am working under windows XP Pro, which dose not provide the ability to set the permission of write, either the the db folder or db file. I am very clear with IIS configuration. It is the only please I can find USER_COMPUTERNAME. How would I configure it? Thanks

Posted By: BecauseofChrist
Date Posted: 08 November 2003 at 4:59pm

I am having a similar problem. I do not know that much about servers and IIS, but I do have IIS set up on my computer at home and at work. At home, I am running XP Pro, and I am running 2000 at work. Right now, I am trying to create a simple script to add a record to a database. It gives me the error, "Cannot update. Database or object is read only." When I upload to my host, it works fine. I have done similar things at work, without having to change any permissions.

Can anyone help me? Any suggestions are greatly appreciated.

Thanks ahead of time.

-------------
http://www.becauseofchrist.com - BecauseofChrist.com

Posted By: BecauseofChrist
Date Posted: 08 November 2003 at 5:42pm

Well, I found how to solve the problem. In XP, you have to turn off simple file sharing. I don't know exactly what this does, and I'm not on a network so I felt safe turning it off. To turn it off, open Windows Explorer and go to Tools, Folder Options, the View tab, and under Advanced Settings there is an option to use simple file sharing at the verry bottom. Uncheck that and you should be able to have the Security tab on the properties of the folder or database you want to give write permissions. I don't know exactly what to do from there, but I just gave all that was listed write permissions and now my script is working fine. I might be doing something I shouldn't somewhere, but I have anything on my PC that I would be scared of anyone else seeing. And I'm just happy that my script is finally working.

-------------
http://www.becauseofchrist.com - BecauseofChrist.com