| Author |
 Topic Search  Topic Options
|
brolinuk 
Newbie
Joined: 24 October 2003
Location: United Kingdom
Status: Offline
Points: 24
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Cannot update. Database or object is read
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
|
 |
Flamewave
Senior Member
Joined: 19 June 2002
Location: United States
Status: Offline
Points: 376
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
KCWebMonkey
Senior Member
Go Chiefs!
Joined: 21 June 2002
Status: Offline
Points: 1319
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
KCWebMonkey
Senior Member
Go Chiefs!
Joined: 21 June 2002
Status: Offline
Points: 1319
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 October 2003 at 2:55pm |
|
|
|
brolinuk
Newbie
Joined: 24 October 2003
Location: United Kingdom
Status: Offline
Points: 24
|
Post Options
Thanks(0)
Quote Reply
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
|
|
BecauseofChrist
Newbie
Joined: 23 February 2003
Location: United States
Status: Offline
Points: 25
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
BecauseofChrist
Newbie
Joined: 23 February 2003
Location: United States
Status: Offline
Points: 25
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
