My application connects to SQL 2012 via ODBC. When I configure the ODBC source to use a SQL Server Native Client driver (either 10 or 11), I get errors with the smalldatetime fields in the database. It works fine with just the SQL Server driver, although that's an older driver. Wondering if I need to do something in my code and/or datawindow to accommodate the Native Client drivers? Or are Native Client drivers not intended for ODBC connections?
The error when inserting a new record from a datawindow is:
Datetime Field Overflow : Fractional second precision exceeds the scale specified in the parameter binding