Connect Django to Sql server 2019

Question

I create a new project in django and i was trying to connect to sql server 2019.

So i install sql-server-2019 and after install , i check if ODBC DRIvers was ok, and as you can see , all ok so far.

The next thing i do , was pip install django-pyodbc-azure

I have more packages instaled because i was testing with everyhing i find , and so far i allways have the same error.

it means conn = Database.connect(connstr, django.db.utils.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name was not found and no predefined driver (0) (SQLDriverConnect) was specified)

and here is my settings.py from django:

I'm stuck here, I don't even know what I can to go on

Take a look at this: stackoverflow.com/questions/17115632/…. You can also check out the fork for it: github.com/ESSolutions/django-mssql-backend — acw
Please replace the images (other than the first one) with text. Include the full stack trace. — aaron
@PedroMariz show DSN de systemas tab and DSN de utilizator tabs as per stackoverflow.com/a/41703602/2067976 answer. — Andriy Ivaneyko

Mario Orlandi Mario Orlandi · Accepted Answer · 2020-12-29T10:31:31

I would try this:

(1) add 'dsn' entry to DATABASES dictionary as follows:

DATABASES = {
   'default': {
       'ENGINE': 'sql_server.pyodbc',
       ...
       'OPTIONS': {
           'driver': 'ODBC Driver 17 for SQL Server',
           'dsn': 'avariagest',
       },
   }
}

(2) Create a "DSN" named "avariagest":

Go to the "DSN de sistema" tab, in the ODBC administration window, then add and entry called "avariagest" with suitable attributes

Connect Django to Sql server 2019

1 Answers