Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

On 11/08/2016 5:11 AM, Evan Roberts wrote:
> I'm struggling to get a project going. I'm new to python and django.
>
> Is django_pyodbc supported on Python 3.5.1 and django 1.9? If not could
> you suggest a combination of python & django that is known to work with
> MS SQL Server 2012?

Not an answer to your specific question but a recommendation to use
PostgreSQL instead. It works brilliantly on Windows and makes life
serene. Much easier to gain python and django experience when the
environment isn't fighting back. You can dump and pump later when you
really need SQL Server.

Mike

>
>
> Here are the details of my virtual environmentÂ
>
> windows 7 64 bit,Â
>
> python 3.5.1 64 bit,Â
>
> packages installed:
>
> |Django (1.9) django-pyodbc (0.4.1) pip (8.1.2) pyodbc (3.0.10) pywin32
> (219) setuptools (19.1) wheel (0.26.0) |
>
>
>
> The database definition in settings.py:
>
> |DATABASES = { 'default': { 'ENGINE': 'django_pyodbc', 'HOST':
> '192.168.10.47', 'PORT': '1433', 'USER': '*********', 'PASSWORD':
> '*******', 'NAME': 'my_db', 'OPTIONS' : { 'driver' : 'SQL Server Native
> Client 11.0', 'MARS_Connection' : True, 'driver_supports_utf8' : True,
> }, } } |
>
>
>
> When I try to run the development server I'm getting these errors:
>
> |(my_db) PS F:\my_db\my_db> python .\manage.py runserver Performing
> system checks... System check identified no issues (0 silenced).
> DRIVER={SQL Server Native Client
> 11.0};SERVER=192.168.10.47;PORT=1433;UID=*****;PWD=******;DATABASE=my_db;MARS_Connection=yes
> Unhandled exception in thread started by <function
> check_errors.<locals>.wrapper at 0x0000000004000D90> Traceback (most
> recent call last): File
> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\utils\autoreload.py",
> line 226, in wrapper fn(*args, **kwargs) File
> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\core\management\commands\runserver.py",
> line 117, in inner_run self.check_migrations() File
> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\core\management\commands\runserver.py",
> line 163, in check_migrations executor =
> MigrationExecutor(connections[DEFAULT_DB_ALIAS]) File
> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\migrations\executor.py",
> line 20, in __init__ self.loader = MigrationLoader(self.connection) File
> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\migrations\loader.py",
> line 49, in __init__ self.build_graph() File
> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\migrations\loader.py",
> line 176, in build_graph self.applied_migrations =
> recorder.applied_migrations() File
> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\migrations\recorder.py",
> line 65, in applied_migrations self.ensure_schema() File
> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\migrations\recorder.py",
> line 56, in ensure_schema with self.connection.schema_editor() as
> editor: File
> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\backends\base\base.py",
> line 604, in schema_editor 'The SchemaEditorClass attribute of this
> database wrapper is still None') NotImplementedError: The
> SchemaEditorClass attribute of this database wrapper is still None|
>
> --
> You received this message because you are subscribed to the Google
> Groups "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to django-users+unsubscribe@googlegroups.com
> <mailto:django-users+unsubscribe@googlegroups.com>.
> To post to this group, send email to django-users@googlegroups.com
> <mailto:django-users@googlegroups.com>.
> Visit this group at https://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/90dab5d0-2f51-4bab-8b93-bdb6e507d6c6%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/90dab5d0-2f51-4bab-8b93-bdb6e507d6c6%40googlegroups.com?utm_medium=email&utm_source=footer>.
> For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/69a83296-7540-755f-898c-241a831cb6bf%40dewhirst.com.au.
For more options, visit https://groups.google.com/d/optout.