Re: Unable to establish odbc connection to MS SQL Server

Lets

On Apr 27, 2020 10:31 PM, "Gurmeet Kaur" <gurmeetkaurjuneja23@gmail.com> wrote:

Hi There,

I have also implemented this in my project. The code in my settings.py is below. You could also try the same.

DATABASES = {
    'default': {
        'ENGINE': 'sql_server.pyodbc',

        'NAME': 'MyDbName',

        'USER': 'user',
        'PASSWORD': 'password',

        'HOST': 'DbHost',
        'OPTIONS': {
            'driver': 'ODBC Driver 13 for SQL Server',
            'unicode_results': True,

        },
    }
}

On Mon, Apr 27, 2020 at 10:22 PM Kirk Brown <brownkirkwilliam@gmail.com> wrote:

I'm getting an error when I try to runserver. Here is my code in manage.py:

DATABASES = {
    'default': {
        'ENGINE': 'sql_server.pyodbc',
        'NAME': 'database',
        'HOST': 'localhost',
        'USER': 'user',
        'PASSWORD': 'password',
                
        'OPTIONS': {'ODBC Driver 17 for SQL Server',
                    }
    }
}

And here is the error:

(venv) C:\Users\Kirk\PycharmProjects\PyShop>manage.py runserver

Unhandled exception in thread started by <function check_errors.<locals>.wrapper at 0x000001770CD61438>

Traceback (most recent call last):

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\utils\autoreload.py", line 225, in wrapper

    fn(*args, **kwargs)

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\core\management\commands\runserver.py", line 109, in inner_run

    autoreload.raise_last_exception()

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\utils\autoreload.py", line 248, in raise_last_exception

    raise _exception[1]

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\core\management\__init__.py", line 337, in execute

    autoreload.check_errors(django.setup)()

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\utils\autoreload.py", line 225, in wrapper

    fn(*args, **kwargs)

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\__init__.py", line 24, in setup

    apps.populate(settings.INSTALLED_APPS)

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\apps\registry.py", line 112, in populate

    app_config.import_models()

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\apps\config.py", line 198, in import_models

    self.models_module = import_module(models_module_name)

  File "C:\Users\Kirk\AppData\Local\Programs\Python\Python37\lib\importlib\__init__.py", line 127, in import_module

    return _bootstrap._gcd_import(name[level:], package, level)

  File "<frozen importlib._bootstrap>", line 1006, in _gcd_import

  File "<frozen importlib._bootstrap>", line 983, in _find_and_load

  File "<frozen importlib._bootstrap>", line 967, in _find_and_load_unlocked

  File "<frozen importlib._bootstrap>", line 677, in _load_unlocked

  File "<frozen importlib._bootstrap_external>", line 728, in exec_module

  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\contrib\auth\models.py", line 2, in <module>

    from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\contrib\auth\base_user.py", line 47, in <module>

    class AbstractBaseUser(models.Model):

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\base.py", line 101, in __new__

    new_class.add_to_class('_meta', Options(meta, app_label))

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\base.py", line 305, in add_to_class

    value.contribute_to_class(cls, name)

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\options.py", line 203, in contribute_to_class

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

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\__init__.py", line 33, in __getattr__

    return getattr(connections[DEFAULT_DB_ALIAS], item)

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\utils.py", line 203, in __getitem__

    conn = backend.DatabaseWrapper(db, alias)

  File "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\sql_server\pyodbc\base.py", line 193, in __init__

    self.driver_charset = opts.get('driver_charset', None)

AttributeError: 'set' object has no attribute 'get'

Any help is much appreciated. Thank you.

--
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 view this discussion on the web visit https://groups.google.com/d/msgid/django-users/7f003a10-2c5e-472f-9bdc-eca8a2e277c1%40googlegroups.com.

--
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 view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAEbKJVgeUofG1zEAcz8GR8ftgQzBET97H8%2B5QPewbOKVvwOm5A%40mail.gmail.com.

--
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 view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAHoC8YXTvPzVNcuwoUa7c-6zzSj2MQtf814zO6b4SAGGwQS2oQ%40mail.gmail.com.