Data changing from Sybase Table
-
- Posts: 4
- Joined: Fri 20 Nov 2020 19:48
Data changing from Sybase Table
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!
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
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.
-
- Posts: 4
- Joined: Fri 20 Nov 2020 19:48
Re: Data changing from Sybase Table
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
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
Thank you for the information. We have fixed the issue, and the fix will be included in the next ODBC Driver for ASE build.
-
- Posts: 4
- Joined: Fri 20 Nov 2020 19:48
Re: Data changing from Sybase Table
Thanks for your reply and for checking the issue.
When will this new version of the driver be available for download?
When will this new version of the driver be available for download?
Re: Data changing from Sybase Table
We are planning to release the next version of ODBC Driver for ASE within the next two to three weeks.
-
- Posts: 4
- Joined: Fri 20 Nov 2020 19:48
Re: Data changing from Sybase Table
Just downloaded version 2.1.4. and hte issue doesn't appear anymore, thanks!!
Re: Data changing from Sybase Table
Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.
Feel free to contact us if you have any further questions about our products.