I am using VB6 with ADO 2.1. I am trying to insert a date value into a column that is of the Date datatype. I am receiving a date conversion failure error. I have tried to format the date with no success. What format does Informix require when inserting a date?
Try using “2000-05-11” as your date format.