Wednesday, August 10, 2016

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

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?


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.
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/90dab5d0-2f51-4bab-8b93-bdb6e507d6c6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment