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

[Gustav Brock]

Hi all

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

    http://stackoverflow.com/questions/39303408/

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.

/gustav