error of database locked

[vabsjava]

HI! everybody
I am giong in all directions of ASP being a beginner. I am getting right with connecting asp page. I am getting right with extracting the data from database using "request.form" but when i try to update the data.....the browser gives an error message the ur database is locked..and hence can't be updated....
Please help me with this error.....
Thank u...

[spattarkine]

Make sure ur IIS is properly installed.Many times this error occours if IIS is corrupt
another best Soluton is use SQL querry Strings


else if u r using ASP syntax make sure u r using
Including adovbs.inc
and after opening the recordset write adopendynamic ,adlockPessimistic .
try this.Make sure the above commands are case sensitive as they are keywords

[vabsjava]

Make sure ur IIS is properly installed.Many times this error occours if IIS is corrupt
another best Soluton is use SQL querry Strings


else if u r using ASP syntax make sure u r using
Including adovbs.inc
and after opening the recordset write adopendynamic ,adlockPessimistic .
try this.Make sure the above commands are case sensitive as they are keywords

HI!
i have tried every possible option known to me....but it is not working...please suggest something different...

[cutamacious]

HI!
i have tried every possible option known to me....but it is not working...please suggest something different...

Are you sure that you are not using a join query????

[vabsjava]

Are you sure that you are not using a join query????

Yes i am not using join query....

[darkdirk1]

just a guess. But you are trying to update a locked table. OR attempting to place an update on a foreign entity. My point is - the message does not sound so much like an error message and an informative message.
You mentioned - extracting database info using request.form...???
Just want to verify with you - that's not database info.

We would probably need to see that query string and the exact error to truly tell you whats. But first have you tried googling the server error code???
How about trimming down your sql query to just a simple Select statement?
Who built this database?

[Bug]

Make sure the UserName you use to connect to this database has permissions to update the table.