Page 1 of 1

Data changing from Sybase Table

Posted: Fri 20 Nov 2020 20:39
by sebastianq
Hello,

I am using Devart's ODBC driver for ASE to connect to a Sybase database, using an ETL app called Easymorph. But i realized some of the data was changed from its original value on the table. It happens on two columns which have data type "money". The issue I have is with negative values between -1 and 0, they are being changed to positive.

When I realized the issue I made the extraction 3 more times, and I noticed only the extractions via Devart's driver had this issue.

1. I extracted the data with easymorph and microsoft access and I had no rows with numbers between -1 and 0.
2. I extracted the same tables using native drivers for sybase, using DBeaver and a proprietary extractor from my enterprise, and the info was correct, showing numbers between -1 and 0 where it should.

I don´t know what is causing this problem, and I think it´s a very particular issue since I could not find any post with a similar problem. Has this happened to anyone? Is there a configuration I have to change when creating the ODBC DSN in order to fix this?

Thanks!

Re: Data changing from Sybase Table

Posted: Wed 25 Nov 2020 07:41
by Stellar
Thank you for providing the information. We've reproduced the issue and started to investigate possible causes of the described behavior. We will let you know the results as soon as we get them.

Re: Data changing from Sybase Table

Posted: Wed 25 Nov 2020 14:49
by sebastianq
Ok.
Please let me know if you need any more explaining on the issue or an example.

I also sent an email to [email protected]

Thanks

Re: Data changing from Sybase Table

Posted: Thu 26 Nov 2020 08:48
by Stellar
Thank you for the information. We have fixed the issue, and the fix will be included in the next ODBC Driver for ASE build.

Re: Data changing from Sybase Table

Posted: Thu 26 Nov 2020 16:06
by sebastianq
Thanks for your reply and for checking the issue.
When will this new version of the driver be available for download?

Re: Data changing from Sybase Table

Posted: Tue 01 Dec 2020 14:49
by Stellar
We are planning to release the next version of ODBC Driver for ASE within the next two to three weeks.

Re: Data changing from Sybase Table

Posted: Tue 29 Dec 2020 19:13
by sebastianq
Just downloaded version 2.1.4. and hte issue doesn't appear anymore, thanks!!

Re: Data changing from Sybase Table

Posted: Wed 30 Dec 2020 13:59
by Stellar
Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.