Login    Register      

Operation must use an updateble query Posted Date: 19 Jun 2012      Posted By:: Surendra Tarai     Member Level: Silver    Member Rank: 1017     Points: 3   Responses: 4
I have deployed an application and it support only DQL query but when I try to run DML query like insert/delete/update then it is throwing error: Operation must use an updateble query I think the database is read-only. But I have checked read-only property of database file, but it is also false, still it is not working and same error. All the best -Thanks & Regards Surendra Tarai +91-9090595512 Syztech Solutions Tweet
Responses
#676228    Author: Shivshanker Cheral      Member Level: Gold      Member Rank: 26     Date: 19/Jun/2012   Rating:     Points: 2 Check the User profile which you are using to insert/update query. let us know What error you are getting and which version of SQL and OS so that we can answer your question Thanks Shivshanker Cheral "If you share your assets (money etc..) it will decrease, But if you share your knowledge it will increase!!! ".   #676316    Author: Anil Kumar Pandey      Member Level: Platinum      Member Rank: 1     Date: 19/Jun/2012   Rating:     Points: 2 There may be an issue in the user permission also, make sure by checking the property of the user in the data base. the user must have the Read , Write and Execute property. Thanks & Regards Anil Kumar Pandey Microsoft MVP, DNS MVM   #676325    Author: Prachi Kulkarni        Member Level: Gold      Member Rank: 25     Date: 19/Jun/2012   Rating:     Points: 1 Hi, Can you please provide error screenshot so that it will be more clear? Regards, Prachi.   #676334    Author: sudhajosyula      Member Level: Gold      Member Rank: 46     Date: 19/Jun/2012   Rating:     Points: 2 Is it are you using Microsoft MSAccess ? If so,try to uncheck the read only.It clearly states that it doesnot have write permission.Please find the identity of the app pool with the IIS and give that identity to Network Service to the folder.
Post Reply
This thread is locked for new responses. Please post your comments and questions as a separate thread. If required, refer to the URL of this page in your new post.
Tweet

Next : Suggest me how i can save the select query inside the temporary table and retrive it later Previous : How to develop a application for petrol bulk Return to Discussion Forum Post New Message Category:

Related Messages Is there any expert to solve this? what is difference between String and string(data type) in c#? what is a resource file... Horizontal Scroll Bar for a listview control sql querry