ADOdc control failing to update database
Posted on 2005-04-23
I am using adodc object to connet to database vie odbc, and it works fine till
the fields get changed(fields are mapped through the adodc), then it cannot update the database.
I get all kind of errors.
I have tried all kind of settings for the adodc, like CursorLocation, CursorType, LockType and Mode.
I've also tried forcing the save, then it fails few times and then saves it, when run from the editor.
Same code when compiled into .exe crashes of course.
My question is whether it's something with the code or it may have to do with the database settings
on the database server?! Any ideas what it should be like?
And I know I can use DAO too but I really want to make it work with the ADO controls if possible.