Porting to Django Linux with SQL Server Backend

2014-10-15 Thread robert brook
The group has been developing locally with sqllite on Windows. We are porting the installation to a Linux environment /windows sql server. Looking for suggestions for database connectors from Linux to sql server 2014 using: python3.3 django 1.7 I have installed a local copy of sql server to try

Re: Porting to Django Linux with SQL Server Backend

2014-10-15 Thread Michael Manfre
It's hard to give constructive feedback without knowing any of the specific errors you encountered, but django-mssql only works on Windows. Depending on the error you encountered with pymssql, you could try django-pymssql (https://github.com/aaugustin/django-pymssql). Regards, Michael Manfre O

Re: Porting to Django Linux with SQL Server Backend

2014-10-15 Thread robert brook
Sorry I guess I should have focused the question better. I have a working connector on my windows machine using django-pyodbc-azure I can and will use this connector on the new Linux installation. Since I have never tested this on a Linux machine yet, I wanted to see if anyone had any successfu

Re: Porting to Django Linux with SQL Server Backend

2014-10-15 Thread Kelvin Wong
I have a working system running Django 1.6/Python 2.7 on RHEL 7 connecting to MSSQL2012 SP 2 on Win Server. On the Linux box we are installing this with Pip requirements: git+https://code.google.com/p/pyodbc@3.0.7#egg=pyodbc django-pyodbc-azure==1.1.5 The local_settings.py contains: DATABASE

Re: Porting to Django Linux with SQL Server Backend

2014-10-16 Thread robert brook
Thanks for your response. I am in the process of porting this. I am concerned that I really only have one potential option of pyodbc-azure in the event that there is a problem. Unfortunately unless I reach a complete stumbling block I will use the pyodbc - azure connector to enable me to conn

Re: Porting to Django Linux with SQL Server Backend

2014-10-16 Thread Kelvin Wong
Your options are limited if you want to connect to a 2012 SQL Server. The azure driver is the only one that would work for us and we tested everything we could find. K On Thursday, October 16, 2014 7:50:15 AM UTC-7, robert brook wrote: > > Thanks for your response. > > I am in the process of p

Re: Porting to Django Linux with SQL Server Backend

2014-10-16 Thread robert brook
Thank you for your response. I saw that you mentioned that you were getting seg faults I noticed on a web site that there was an entry that might overcome that problem http://www.kcaran.com/entries/technology/linux/linuxodbc.html *** sing Red Hat, you may get a ‘Segmentation Fault’