Page 1 of 1

ODBC driver for SAP ASE

Posted: Mon 28 May 2018 05:37
by nohez
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,

Re: ODBC driver for SAP ASE

Posted: Wed 13 Jun 2018 08:22
by Stellar
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.

Re: ODBC driver for SAP ASE

Posted: Wed 13 Jun 2018 11:13
by nohez
Ok. Please update me when you address the rounding of large values in money datatype. I will then continue my evaluation.

Re: ODBC driver for SAP ASE

Posted: Tue 17 Jul 2018 12:18
by MaximG
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: