[egenix-users] mxODBC bigint fetched as float

[Tim Morgan]

I have been using the mxODBC Zope DA for some time now and it's been
great. Our agency recently upgraded Zope to version 2.7 with Python 2.3,
and the Database Adapter now returns BIGINTs as FLOATs. This is a bit of
a problem for all our applications currently in use because we use
BIGINT in several of our tables and the floats being returned are
unexpected.
 
I opened up a command prompt and connected with mxODBC and got the same
result (so it's not just the DA).
 
We use:
* MS SQL Server 2000
* Windows 2000 Server
* Zope 2.7
* Python 2.3

I have downloaded the latest version of the Database Adapter and still
have the same problem.

Any help would be greatly appreciated. Thanks.
 
~~~
Tim Morgan, I.T. Spec. * Family & Children's Services * (918) 560-1131 *
tmorgan at fcsok.org <mailto:tmorgan at fcsok.org> 




CONFIDENTIALITY NOTICE:  This email, including any attachments, is intended only for the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable laws.  If the reader of this message is not the intended recipient, you are hereby informed that any review, use, disclosure, distribution or copying of this communication is strictly prohibited.  If you have received this communication in error, please contact the sender by reply email and delete all forms of the original message from your system.  Thank you.

This e-mail and all other electronic (including voice) communications from the sender's agency are for informational purposes only.  No such communication is intended by the sender to constitute either an electronic record or an electronic signature, or to constitute any agreement by the sender to conduct a transaction by electronic means.  Any such intention or agreement is hereby expressly disclaimed unless otherwise specifically indicated.  To learn more about our agency, please visit our website at http://www.fcsok.org.