Hi List I'm tring to insert a timestamp Using DBI 1.14, ActiveState 5.6, Access 2000 SQL =INSERT INTO tblCar (date_now,time_now) VALUES (#06/23/2003#,#16:13#) Results in DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect (SQL-07001)(DBD: st_execute/SQLExecute err=-1) at C:\project\parse\callback2.pl line 100. [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect (SQL-07001)(DBD: st_execute/SQLExecute err=-1) at C:\project\parse\callback2.pl line 100.
However it works when running directly in Access. (If I remove the time_now it works thru the DBI) Can't figure out the error code. Help appreciated. Regards Clinton
