Friday, October 30, 2015

Re: mssql databASE CONNECTION to Django

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/f8e03eff-d288-44df-889f-6bfc97116cb8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment