[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:

    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


More information about the dba-SQLServer mailing list