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:p...@10.0.8.30/TaxDB?DRIVER={FreeTDS}',
migrate=False)
elif os.name=='nt': #Windows
db = DAL('mssql://u...@127.0.0.1/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.
