E_FAIL SOLUTION HERE!!!!

[arrudatr]

i am using VB6
i had same error and i found that

table =reservation
columns
id integer auto
date date 0000-00-00
time time 00:00:00

when i enter time value as "00:00:00" mysql accept it but after it u cant use table anymore with error E_FAIL . when i deleted the record with 00:00:00 i can continue with no problem.....

first record
date--- 07.03.2007
time--- 00:00:00

record success

second record
date--- 09.03.2007
time--- 11:30:00

OR

date--- 07.03.2007
time--- 00:00:00


Provider or other service returned an E_FAIL status Error

when i delete record with time valur "00:00:00"

date--- 09.03.2007
time--- 11:30:00

record success

NEWER ENTER DATE OR TIME VALUE AS 0000-00-00 or 00:00:00