Devart Forums

I am currently evaluating the Devart ODBC driver for SAP ASE on Linux using unixODBC v2.3.0 and ASE 16.0 SP02 PL03.

I am facing three problems.
1. querying datetime value gives incorrect results.
2. money values are rounded off to zero decimals.
3. column with NULL values are reported as blanks.

For eg:

SQL> create table #tmp (a datetime null, b money null, c char NULL)
SQLRowCount returns 0
SQL> insert #tmp values ('1 Apr 2018 1:00 PM', 922337203685477.5807, NULL)
SQLRowCount returns 1
SQL> select * from #tmp
+------------------------+----------------------+--+
| a | b | c|
+------------------------+----------------------+--+
| 18 13.000 | 922337203685478 | |
+------------------------+----------------------+--+
SQLRowCount returns -1


Is there any configuration required at driver level to correct the above?

Thanks & regards,

1. Thank you for the information. We have fixed the issue with the display of DateTime field values, and the fix will be included in the next Devart ODBC driver for SAP ASE build.
2. Double has approximately 15 digits of accuracy, so the value of 922337203685477.5807 is rounded to 15 characters.
We will investigate the issue of rounding large values for the Money type, perhaps we will change the type to transfer large values.
3. UnixODBC for the "c" field that has the char type requests a value as a string, therefore, NULL is displayed as an empty value.

Ok. Please update me when you address the rounding of large values in money datatype. I will then continue my evaluation.

On 16-Jul-18 we released a new version 1.4.8 that includes the changes you need. A full list of changes can be found by the link: https://www.devart.com/odbc/ase/revision_history.html