database updation
-
i have got another problem i have got a insert statement using which i update my database in the local system it is happening good in the local system... now coming to application which is put on the webserver now my database is not updating properly i am getting an exception. i am using server.mappath("dls.mdb"); dls.mdb is my databse name and server.mappath is returning exactly the path on the remote system (like d:/mywebsite/dls.mdb). please solve me and let me knwo
-
i have got another problem i have got a insert statement using which i update my database in the local system it is happening good in the local system... now coming to application which is put on the webserver now my database is not updating properly i am getting an exception. i am using server.mappath("dls.mdb"); dls.mdb is my databse name and server.mappath is returning exactly the path on the remote system (like d:/mywebsite/dls.mdb). please solve me and let me knwo
Define "not updating properly" Do you get an error ? Can you select data from this db ? Is the file read only ?
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog
-
Define "not updating properly" Do you get an error ? Can you select data from this db ? Is the file read only ?
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog
the exception which i get is System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Details.btnsubmit_Click(Object sender, EventArgs e) in the webserver and the file is not read only
-
the exception which i get is System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Details.btnsubmit_Click(Object sender, EventArgs e) in the webserver and the file is not read only
A great way to solve error issues is to google the error message. I found this: http://support.microsoft.com/default.aspx/kb/830977[^] In a nutshell: This problem occurs when a Microsoft Access database file is used as your database source because you must grant write access to both the default worker process identity and the authenticated user.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog
-
A great way to solve error issues is to google the error message. I found this: http://support.microsoft.com/default.aspx/kb/830977[^] In a nutshell: This problem occurs when a Microsoft Access database file is used as your database source because you must grant write access to both the default worker process identity and the authenticated user.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog
thanks a lot dude i fighting from yesterday thanks a lot bye
-
thanks a lot dude i fighting from yesterday thanks a lot bye
our website is being hosted by some other people sir and now i have changed write permission and i updated on the webserver still the same problem is coming do i need to publish my site once again and update all of them or only the databasse file has to replaced sir thanking u bye