Data changing from Sybase Table

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
sebastianq
Posts: 4
Joined: Fri 20 Nov 2020 19:48

Data changing from Sybase Table

Post by sebastianq » Fri 20 Nov 2020 20:39

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!

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: Data changing from Sybase Table

Post by Stellar » Wed 25 Nov 2020 07:41

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.

sebastianq
Posts: 4
Joined: Fri 20 Nov 2020 19:48

Re: Data changing from Sybase Table

Post by sebastianq » Wed 25 Nov 2020 14:49

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

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: Data changing from Sybase Table

Post by Stellar » Thu 26 Nov 2020 08:48

Thank you for the information. We have fixed the issue, and the fix will be included in the next ODBC Driver for ASE build.

sebastianq
Posts: 4
Joined: Fri 20 Nov 2020 19:48

Re: Data changing from Sybase Table

Post by sebastianq » Thu 26 Nov 2020 16:06

Thanks for your reply and for checking the issue.
When will this new version of the driver be available for download?

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: Data changing from Sybase Table

Post by Stellar » Tue 01 Dec 2020 14:49

We are planning to release the next version of ODBC Driver for ASE within the next two to three weeks.

sebastianq
Posts: 4
Joined: Fri 20 Nov 2020 19:48

Re: Data changing from Sybase Table

Post by sebastianq » Tue 29 Dec 2020 19:13

Just downloaded version 2.1.4. and hte issue doesn't appear anymore, thanks!!

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: Data changing from Sybase Table

Post by Stellar » Wed 30 Dec 2020 13:59

Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.

Post Reply