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

     

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.

 

Related Tags for Data Provider or other service returned an E_FAIL status Error:
c,  database,  datetime,  date,  data,  time,  io,  default,  value,  field,  change,  tab,  for,  ie,  solution,  was,  to,  base,  ld,  e,  hang,  ul,  im,  fault,  in,  no,  as,  m,  tr,  os,  os,  ase,  alt,  me,  try,  s,  so,  at,  ha,  ime,  va,  uti,  s,  s,  th,  ab,  alu,  hat,  efault,  nd,  on,  ol,  o

More Tutorials from this section

• MySQL Tutorial - SQL Tutorials
• Data Provider or other service returned an E_FAIL status Error
• Date validation in JSP
• Welcome to the MySQL Tutorials
• Login Authentication in JSP
• MySQL 5.0 Release - Download MySQL 5.0
• MySQL Access Control
• MySQL Administrator
• Backing Up and Restoring A MySQL Database
• MySQL Books
• MySQL Client
• MySQL Client
• MySQL Create Database
• MySQL Database
• MySQL Download
• MySQL Download
• MySQL For Window
• MySQL Front
• MySQL Manual
• MySQL Network