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.

Data Provider or other service returned an E_FAIL status Error

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.