you can try with mxodbc http://www.egenix.com/products/python/mxODBC/
2010/7/30 mwolfe02 <[email protected]> > For background, refer to related questions on SO: > http://stackoverflow.com/questions/3364699/ > http://stackoverflow.com/questions/3371795/ > > I'm developing my app on Windows, but will be deploying it on a Linux > server. The following lines are from the top of my db.py: > > if os.name=='posix': #Ubuntu > db = > DAL('mssql://user:[email protected]/TaxDB?DRIVER={FreeTDS}<http://user:[email protected]/TaxDB?DRIVER=%7BFreeTDS%7D> > ', > migrate=False) > elif os.name=='nt': #Windows > db = DAL('mssql://[email protected]/TaxDB_Dev? > Trusted_Connection=Yes', migrate=False) > > The problem I am running into is that on Windows, my MS SQL money > fields are returned as Python Decimals. However, on Linux, those same > fields are returned as floats. I think the issue is with FreeTDS. > The above lines are the _only_ lines that are different between my > production and development versions. Obviously, the environments > themselves are vastly different. > > Is there an alternative to FreeTDS to connect to SQL Server from > Linux? Do I need to provide some additional info in my connection > string? Am I just stuck because I'm accessing SQL Server from Linux? > > Thanks in advance for any insight.
