₦airaland Forum

I built an .asp program to post data to my data base but it keeps giving error.

I keep getting Cannot Update: database or object is read only any time I try to post input on a form to my table. It works perfectly on my desktop but once uploaded, it doesn't work.


Please I need help from any one experience here.

check if you have update permission on the database. Are u using Access DB ?

post your code so that we can look at it

This is a write permission issue
ensure that u have a write permission on the folder that contains the database!
This u can verify from ur host.

similar issue
On Wednesday 10/4/2006 4:03:03 AM Allan Parson said:
Hello Imar,
Thank you for a great article.
I ran the sample web site on my workstation, and it worked fine.
But when I uploaded the same site to my hosting company,
it generated "HTTP 500 - Internal server error " right after
I enter my credentials in the Login.aspx page and click Login button.
Although, if I enter the wrong credentials, it asks me to enter the right ones which means that it works to some point.

Could you kindly tell me what might be a problem?

Thanks a lot.

Allan
Allan

On Wednesday 10/4/2006 4:09:32 AM Imar Spaanjaars said:
Hi Allan,

This sounds like a security issue. A failed Login doesn't write to the database, while a successfull login does which means the account used by the webserver needs write permission to the database and its folder. Check out this FAQ for solutions to this problem:

http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=263

Cheers,

Imar


On Wednesday 10/4/2006 5:46:34 AM Allan Parson said:
Hi Imar,

You was exactly right. That was a 'write' permission to a DB file problem.
Thanks a lot!
Allan