Last post Aug 18, 2008 12:38 AM by c_andy
Aug 16, 2008 10:59 PM|c_andy|LINK
My website worked perfectly on my pc but it is now on a hosting server. When i test my forms, the ones where the data from the form has to be inputted into the database i get a runtime error and when i check the error this is what i get. when i research the
error online i got alot of solutions. MS database does not have a read write permissions and there are a number of solutions to change the permission but it seems as if everyone i tried isn't working (or i am not sure if i am doing it right).
Operation must use an updateable query.
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated
in the code.
System.Data.OleDb.OleDbException: Operation must use an updateable query.
command.Parameters.Add(New OleDbParameter("@Password1", Password1.Text))
i know its something to do with access permissions. it supposed to be read write. at least i think thats what it is. i already set up my dsn on the hosting server. i dont kno what to do. can u help me
Aug 17, 2008 04:32 AM|Mikesdotnetting|LINK
You have to apply MODIFY permissions to the NETWORK SERVICE account on the
folder that contains the database.
Aug 17, 2008 07:59 PM|c_andy|LINK
But isn't it the hosting server that is supposed to apply the permissions to my database? because when i apply the permission to my database on my pc then upload it through the ftp to the site i still get the same error. so i would have to contact the hosting
server right? i am using godaddy.
Aug 18, 2008 12:38 AM|c_andy|LINK
ok i got it thanks.