Skip to content
This repository has been archived by the owner on May 7, 2024. It is now read-only.

ODBC driver incorrectly converting a decimal into an exponetial number #88

Open
minifiredragon opened this issue Nov 29, 2021 · 0 comments

Comments

@minifiredragon
Copy link

Yes, I am using ODBC, why? Because QODBC, A Quickbooks server interface, uses it to access Quickbooks.

The issues, when I query a field that is decimal it returns an exponential number.

Example: 1.29119897569E-307 is what is returned for 1.98867.

Here is what I tested, their VB Demo tool returns the correct number thru ODBC. I loaded up a PHP server and that too returned the correct number. I am hoping someone familiar with the inner workings of OpenBD will know where to look. Or if someone can point me in the right direction to try and repair the error myself, that would be ok. I am assuming the error maybe in the ODBC.jar file?

As for Java, I am using 8, and I dropped in the missing ODBC drivers from version 6. So far everything is working fine. When I send a decimal to Quickbooks it goes correctly.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant