How to connect remote SQL server with Django 2

Question

I was trying to connect my Django 2 project with a remote SQL server my connection string is

'default': {
        'ENGINE': 'sql_server.pyodbc',
        # 'ENGINE': 'django_pyodbc',
        'NAME': 'hrm5',
        'USER': 'sa',
        'PASSWORD': '12345',
        'HOST': 'Remote Ip',
        'PORT': '1433',
        'OPTIONS': {
            'driver': 'ODBC Driver 11 for SQL Server',
        },
    }

I install pyodbc-azure & django-mssql But still getting this error

django.db.utils.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 11 for SQL Server' : file not found (0) (SQLDriverConnect)")

Also, I'm using Linux Mint-19 OS and SQL server -v is 12

How you resolved this issue?

Hafiz Siddiq
– Hafiz Siddiq

2020-03-05 18:22:33 +00:00
Commented Mar 5, 2020 at 18:22 — Hafiz Siddiq
– Hafiz Siddiq, Commented Mar 5, 2020 at 18:22

Dylan Chavez · Accepted Answer · 2018-10-16 08:15:52Z

2

Your problem is solve here using Django version 2.0.4 and its using this library django-pyodbc-azure 2.0.4.1

answered Oct 16, 2018 at 8:15

Dylan Chavez

1093 bronze badges

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

1 Comment

Antu Over a year ago

I just install pyodbc-azure and the error code change not getting solution still yet have a look my edit question

Collectives™ on Stack Overflow

How to connect remote SQL server with Django 2

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related