django-mssql - Invalid connection string attribute

Question

This is the error I am getting when I run the django web server.

django.db.utils.OperationalError: (com_error(-2147352567, 'Exception occurred.', (0, u'Microsoft OLE DB Provider for SQL
 Server', u'Invalid connection string attribute', None, 0, -2147217843), None), u'Error opening connection: DATA SOURCE=
server1;Initial Catalog=Misc;UID=DOMAIN\\dcullen;PWD=******;PROVIDER=SQLOLEDB;MARS Connection=True')

settings.py

...
DATABASES = {
    'default': {
        'NAME': 'Misc',
        'ENGINE': 'sqlserver_ado',
        'HOST': 'server1',
        'USER': 'DOMAIN\\dcullen',
        'PASSWORD': 'PWD',
        'OPTIONS': {
            'provider': 'SQLOLEDB',
            'use_legacy_date_fields': 'True'
        }
    }
}
...

connection-strings.com seems to indicate that the driver is not for SQL Server 2012 but SQL Server 2000.

Python version: 2.7 Django version: 1.7.11 django-mssql version: 1.7

Package homepage: https://bitbucket.org/Manfre/django-mssql/

Danny Cullen · Accepted Answer · 2016-05-16 14:11:35Z

1

I found the answer now, I was using the wrong provider.

Changing to Provider=SQLNCLI11 solved the issue.

answered May 16, 2016 at 14:11

Danny Cullen

1,8425 gold badges32 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

alexander.polomodov · Accepted Answer · 2018-04-03 06:07:27Z

0

try these settings. Hope this helps

DATABASES = {
    'default': {
        'ENGINE': 'sqlserver_ado',
        'NAME': '',
        'USER': '',
        'PASSWORD': '',
        'HOST': '',
        'PORT': '1433',
         'OPTIONS': {
            'provider': 'SQLOLEDB', #SQLNCLI11 , SQLOLEDB
            'use_legacy_date_fields': 'True',
            #'extra_params' : 'DataTypeCompatibility=80;MARS Connection=True',
            #'connect_timeout': 0
            }
    }
}

edited Apr 3, 2018 at 6:07

alexander.polomodov

5,54414 gold badges44 silver badges48 bronze badges

answered Apr 3, 2018 at 5:45

Dheeraj Inampudi

1,46717 silver badges13 bronze badges

Collectives™ on Stack Overflow

django-mssql - Invalid connection string attribute

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related