Database WebService
-
I am implementing a webservice that link to a database on the server machine, The operation on SELECT function work alright. However, operation such as INSERT, DELETE doesn't work at all. Could any one suggest why? I have tried various ways of INSERTing, I have tried using OleDbCommand as well as OleDbDataAdapter... but none of it works. The database I am using in MS Access though. Thank you in advance
-
I am implementing a webservice that link to a database on the server machine, The operation on SELECT function work alright. However, operation such as INSERT, DELETE doesn't work at all. Could any one suggest why? I have tried various ways of INSERTing, I have tried using OleDbCommand as well as OleDbDataAdapter... but none of it works. The database I am using in MS Access though. Thank you in advance
Paste the stack trace
-
I am implementing a webservice that link to a database on the server machine, The operation on SELECT function work alright. However, operation such as INSERT, DELETE doesn't work at all. Could any one suggest why? I have tried various ways of INSERTing, I have tried using OleDbCommand as well as OleDbDataAdapter... but none of it works. The database I am using in MS Access though. Thank you in advance
IIRC, when an Access db is opened, the default mode is read-only. SELECT will work fine, but any attempt to modify the data will fail, regardless of user permissions. There are optional flags that can be set while creating the connection which override the defaults, though I don't remember where they're defined at the moment. Try MSDN - I was working with ADO when I bumped into this, so that might be a good section to start searching. Boredom, Bull$^%&, Baggage, Bar - all start with 'B'
Coincidence?