Data Provider or other service returned an E_FAIL status Error
In was developing a form in Visual Basic and got the error "Data Provider or other service returned an E_FAIL status Error" while moving the Record Set forward.
On trying for the solution I found that there was a datetime field in the database whose default value was "0000-00-00 00:00:00". I changed the defualt value to Łnow()".
Solution One:
Make sure that null values are invalid date("0000-00-00 00:00:00") is not saved into datbase.
I used the following sql query to do so:
ALTER TABLE `mytable` CHANGE `record_createTime` `record_createTime` DATETIME NOT NULL DEFAULT 'now()';
After doing so program started working and error was gone.
Solution 2:
While adding record, add some valid date into the database. You can set the value to now() when user clicks on the save button.