- Tracy Lamb
- PowerBuilder
- Sunday, 18 March 2018 03:43 PM UTC
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
TIA,
~~~Tracy
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.