aaugustin / django-pymssql Goto Github PK

MS SQL Server 2016 Enterprise introduced "Always Encrypted" feature
https://msdn.microsoft.com/en-us/library/mt163865.aspx.

Is there a plan to support it in django-pymssql?

Hello, any news on the Django 1.8 compatibility front? What's the problem exactly?

I was getting an Adaptive Connection Failed (SQL Server 2014) that ended up being a password that was too long. This problem is at the pymssql level: it works with pyodbc, but is probably worth documentating, as I was banging my head against this for a while. I'll mention to pymssql also.

Does this support SQL Azure?
Could not find it in the documentation.

this package wraps django-mssql. the README says it was tested on django-mssql 1.6.x and MSSQL 2012 but should work on 2005/8. If you just pip install django-pymssql, the most recent version of django-mssql installs (2.x.x) . However, 2.x.x does not support MSSQL 2005/8, 1.6.x does. It would be helpful to add a comment to clarify this to the README as well as to specify the version in setup.py and/or add a requirements.txt. Something as simple as:

Note: MSSQL 2005/8 requires django-mssql 1.6.x

Hi, I'm using pymssql from a django framework on centos7 on viirtualbox to Ms SqlServer 2008 R2 Express. I'm using the meta instrtuction like db_table=schema].[table.
When django generate the sql create a "create index" statement with name the schema and table separated with point. That's the generated error "django.db.utils.ProgrammingError: (102, "Incorrect syntax near '.'.DB-Lib error message 20018,".

I have an SQL server that requires connection on a specific port, however specifying the port in the database connection settings have no effect

I don't know what is the development roadmap, but with the current progress, I can use django-pymssql?

Hi Aymeric,
Hope you are doing well. I am working on a Django app that uses django-pymssql. It works great on SQL Server, however if I try to run the same app with my Azure SQL Database it fails.

It is because the stored proc - sp_MSforeachtable is not supported on Azure SQL Database.

Here is my error message when I run python manage.py migrate:

File "/Library/Python/2.7/site-packages/sqlserver_ado/base.py", line 292, in disable_constraint_checking
cursor.execute('EXEC sp_MSforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"')
File "pymssql.pyx", line 462, in pymssql.Cursor.execute (pymssql.c:6514)
pymssql.ProgrammingError: (2812, "Could not find stored procedure 'sp_MSforeachtable'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")

What would be your recommendation in getting migrations to work for Azure SQL Database the same as SQL Server. As of now, my work around is using SSMS to create the stored proc so that django-pymssql can use it. However, for a pure linux/mac environment that will be difficult.

Please let me know.

Thanks,
Meet