[egenix-users] mxODBC bigint fetched as float

[Tim Morgan]

You were right. I reinstalled the database driver and all is well now.

Thanks for your quick response and pointing me in the right direction. 

> -----Original Message-----
> From: M.-A. Lemburg [mailto:mal at egenix.com] 
> Sent: Wednesday, February 16, 2005 10:36 AM
> To: Tim Morgan
> Cc: egenix-users at lists.egenix.com
> Subject: Re: [egenix-users] mxODBC bigint fetched as float
> 
> Tim Morgan wrote:
> > 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.
> 
> We didn't change anything in this area, so this must be 
> related to either the ODBC driver or the database.
> 
> Note that BIGINTs are returned as Python long objects by 
> mxODBC, if the database tells mxODBC that the columns are of 
> this type.
> Only DECIMAL, FLOAT etc. are returned as floats.
> 
> It is possible that Zope 2.7 introduced some change related 
> to Python longs, but I'm not aware of anything in this area.
> 
> > 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.
> 
> --
> Marc-Andre Lemburg
> eGenix.com
> 
> Professional Python Services directly from the Source  (#1, 
> Feb 16 2005)
>  >>> Python/Zope Consulting and Support ...        
> http://www.egenix.com/
>  >>> mxODBC.Zope.Database.Adapter ...             
> http://zope.egenix.com/
>  >>> mxODBC, mxDateTime, mxTextTools ...        
> http://python.egenix.com/
> ______________________________________________________________
> __________
> 
> ::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for 
> free ! ::::
> 
> 



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.