[dba-SQLServer] Trap when updating time only in SQL Server via ODBC

Gustav Brock gustav at cactus.dk
Sat Sep 3 08:07:37 CDT 2016

Hi all

There is a trap in updating time via ODBC in SQL Server with the dbFailOnError option which I haven't met before:


where a time value will be stored with today's date and not the zero-date of Access/VBA, 1899-12-30.

The work-around seems to be either to pass the value as text(!) or to use a query with data type specified parameters.


More information about the dba-SQLServer mailing list