[dba-SQLServer] Trap when updating time only in SQL Server via ODBC
gustav at cactus.dk
Sat Sep 3 08:07:37 CDT 2016
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