Re: mssql databASE CONNECTION to Django

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

On Friday, October 30, 2015 at 9:53:42 AM UTC-4, Sid wrote:

so which version will be compatible...

On Friday, October 30, 2015 at 7:54:26 AM UTC-4, Tim Graham wrote:

django-mssql doesn't support Django 1.8 yet:

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

On Thursday, October 29, 2015 at 9:36:38 PM UTC-4, Sid wrote:

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 

--
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 http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/c2c7265d-6495-475b-b963-8d7c54ea9cec%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.