this is the ADP group. if it is an Access MDB you are dealing with , I
suggest the access news group.
if it is an ADP then you should be using the sQL Driver instead of the
access driver.


"Andrew Chalk" <achalk@XXXmagnacartasoftware.com> wrote in message
news:uMQIyz8SDHA.2004@TK2MSFTNGP11.phx.gbl...
> I execute an SQL INSERT command to a record that contains a 'datetime'
> format field from my C++ program. When the connection is to SQL server it
> works fine. However, when the connection is to the MS-Access ODBC driver
> SQLExecute() returns -1 and SQLGetDiagRec() reports:
>
> 07/16/03,13:56:02. File: .\SQLQuery.cpp. Line: 655:
> 0x0=::SQLGetDiagRec(HandleType=SQL_HANDLE_STMT, Handle=0x007E4978, Record
> No=1, Msg.=[Microsoft][ODBC Microsoft Access Driver]Invalid datetime
format
> (null))
>
> I can't find any references to the Access driver's incompatibility with
the
> SQL DATETIME type. Does anyone have any idea what's going on?
>
> Also, any idea how to go about debugging this?
>
> Many thanks.
>
>