Datetime problem

Posted in 1998

Philippe Fornaciari — Mon, 13 Apr 1998 15:25:41 -0600 — source: Informix-list mailing list archive (1991-1998)

Hi all, I am using VB 5 and ADO to access an Informix database via Intersolv 3.01 ODBC. I just tried to convert a program using RDO to ADO, and I have now error message for each Datetime column of the table I want to update (insert, or update) using the method Update on my recordset (myrs.Update) : S1000 Error in parameter 3. Microsoft OLE DB Provider for ODBC Drivers -2147217887 Errors occurred The parameter 3 is the Datetime column (seen in the ODBC trace). I have the problem when I change the value of the Datetime field (update table set datetimefield = ? where ......), and I have the same problem when I don't modify this value (update table set col=... where .... and datetimefield = ? and ....). This program worked fine with RDO, I just changed RDO to ADO. Thank you for your help. p.fornaciari@summittechnologies.com