mssql databASE CONNECTION to Django

[Sid]

Hi all,

I am trying to connect database which is in server to django, but it is showing many errors like(platform i am using M visual studio)

Traceback (most recent call last):

  File "C:\Users\speesary\Desktop\programs\learn\learn\manage.py", line 17, in <module>

    execute_from_command_line(sys.argv)

  File "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\core\management\__init__.py", line 351, in execute_from_command_line

    utility.execute()

  File "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\core\management\__init__.py", line 325, in execute

    django.setup()

  File "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\__init__.py", line 18, in setup

    apps.populate(settings.INSTALLED_APPS)

  File "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\apps\registry.py", line 108, in populate

    app_config.import_models(all_models)

  File "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\apps\config.py", line 198, in import_models

    self.models_module = import_module(models_module_name)

  File "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\importlib\__init__.py", line 37, in import_module

    __import__(name)

  File "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\contrib\auth\models.py", line 41, in <module>

    class Permission(models.Model):

  File "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\models\base.py", line 139, in __new__

    new_class.add_to_class('_meta', Options(meta, **kwargs))

  File "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\models\base.py", line 324, in add_to_class

    value.contribute_to_class(cls, name)

  File "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\models\options.py", line 250, in contribute_to_class

    self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())

  File "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\__init__.py", line 36, in __getattr__

    return getattr(connections[DEFAULT_DB_ALIAS], item)

  File "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\utils.py", line 240, in __getitem__

    backend = load_backend(db['ENGINE'])

  File "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\utils.py", line 111, in load_backend

    return import_module('%s.base' % backend_name)

  File "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\importlib\__init__.py", line 37, in import_module

    __import__(name)

  File "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\backends\sqlserver_ado\base.py", line 5, in <module>

    from django.db.backends import BaseDatabaseWrapper, BaseDatabaseFeatures, BaseDatabaseValidation, BaseDatabaseClient

ImportError: cannot import name BaseDatabaseWrapper

The Python REPL process has exited

code in my settings.py

PACKAGES ADDED:

from django.db.backends.base.base import BaseDatabaseWrapper

from django.db.backends.base.client import BaseDatabaseClient

from django.db.backends.base.creation import BaseDatabaseCreation

from django.db.backends.base.features import BaseDatabaseFeatures

from django.db.backends.base.introspection import BaseDatabaseIntrospection

#from django.db.backends.base.introspection import FieldInfo, TableInfo

from django.db.backends.base.operations import BaseDatabaseOperations

from django.db.backends.base.schema import BaseDatabaseSchemaEditor

from django.db.backends.base.validation import BaseDatabaseValidation

from django.db.backends.util import CursorWrapper

from os import path

'default': {

        'ENGINE': 'django.db.backends.sqlserver_ado'  ,                                                                #'django.db.backends.sqlserver_ado'

        'NAME': 'Siddharth',

        'USER': 'SCGLOBAL\speesary@ALMDATA',

        'PASSWORD': '',

        'HOST': '127.0.0.1',

        'PORT':'',

        'OPTIONS': {

     

        'driver':'SQL Server Native Client 11.0',

        'MARS_Connection': True,

can anyone please tell me the procedure how to do it. it will be very helpful...

your help is much appreciated

Thanks 

[Tim Graham]

django-mssql doesn't support Django 1.8 yet:

https://django-mssql.readthedocs.org/en/latest/changelog.html

[Sid]

so which version will be compatible...

[Tim Graham]

Please read the documentation: https://django-mssql.readthedocs.org/en/latest/quickstart.html

[Sid]

sorry tim I know I am asking a dumb question...can you please tell me what is the best way to make it work please if possibe...because I am struck form last 2 days

[Tim Graham]

Sorry, I haven't used the library myself and can't provide any additional help.

[Sid]

np...but thanks for your time

[Collin Anderson]

Hello,

I'd recommend using django 1.7 until mssql gets compatible with django 1.8.

Thanks,

Collin