prb using Date/time field with DBI , odbc connected with Access 2000

[Emmanuel Jaeckert]

Hi,

I have some problems using date/time field with DBI and a MS Access Database
over ODBC.

I try to insert a record containig a date :
$res = $dbh->do("INSERT INTO SIT_PREVISIONNEL_HISTO (......., DATEMAJ,
.....) values (......,$rec->{majdate},.....)

$rec->{majdate} come from another table and i got it without a problem with
a SELECT query.

DBI trace shows that :

dbd_preparse scanned 2 distinct placeholders
dbd_st_prepare'd sql f61546664
 INSERT INTO SIT_PREVISIONNEL_HISTO
                                (...,...,...,DATEMAJ,...)
                                values (...,...,...2002-02-05 15??,...);
2   <- prepare= DBI::st=HASH(0x38b54d0) at DBI.pm line 930.
    -> execute for DBD::ODBC::st (DBI::st=HASH(0x38b54d0)~0x38b54f4)
    dbd_st_execute (for sql f61546664 after)...
st_execute/SQLExecute error -1 recorded: [Microsoft][Pilote ODBC Microsoft
Access]Champ COUNT incorrect  (SQL-07001)(DBD: st_execute/SQLExecute err=-1)
    !! ERROR: -1 '[Microsoft][Pilote ODBC Microsoft Access]Champ COUNT
incorrect  (SQL-07001)(DBD: st_execute/SQLExecute err=-1)'

i don't know why perl found 2 placeholders where none existed...
I'm relatively new to perl and i have certainly missed something in the
syntax.

TIA
Emmanuel