Hi Erhan,
Which version of Uniface are you using? And from which version of the SQL Server and client did you upgrade.
There was a problem with the SQL Server Native Client and smalldatetime in the past, and we used to have a note in the documentation:
"Environment Considerations for Microsoft SQL Server
SQL Server Native Client 10.0
The following are known issues when using SQL Server Native Client 10.0 for SQL Server 2008:
The E9 packing code (which maps to the smalldatetime storage format) fails when storing a value other than null. As workaround, consider using the SQL Server 2005 Native Client, which was delivered with SQL Server 2005, to connect to the SQL Server 2008."
Here's a old blog that describes the mentioned issue:
>
SQL Server Native Client 10.0 - Datetime field overflow The problem also should not occur with the "old" SQL Server ODBC driver, but it does not support all the functionality provided by the Native Clients.
I hope this helps.
Thanks,
Daniel
------------------------------
Daniel Iseli
Principal Technical Support Engineer
Uniface Services
Rocket Software, Switzerland
------------------------------
Original Message:
Sent: 12-16-2021 04:15
From: Erhan Gunbulut
Subject: Datetime field overflow
Hi,
Since we upgraded database to SQL Server 2016 with ODBC driver Native Client 11.0 we get errors by updating a datetime field:
Server: 22008 [Microsoft][SQL Server Native Client 11.0]Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding.
It is for all fields which are defined as smalldatetime in the database.
We must use native client driver for Sql Server 2016 otherwise can't get connect to database.
Do you had a similar problem or is there a solution for this problem?
Best regards,
Erhan
------------------------------
Erhan Gunbulut
Sogeti Nederland B.V.
------------------------------