search

lionheart / django-pyodbc

An ODBC-powered MS SQL Server DB backend for Django 1.4+
Apache License 2.0
202 stars 102 forks source link

Sql server 2019 connection string issue from django project #171

Open MrArif-5 opened 3 years ago

MrArif-5 commented 3 years ago

### Issue : django.db.utils.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)') am connecting windows authentication sql serer 2019 no user name and password My connection string : Django Project

DATABASES = { 'default': { 'ENGINE': 'sql_server.pyodbc', 'HOST': 'SAYED-ZEESHAN\SQLEXPRESS', 'NAME': 'EmployeeDB', 'PORT': '1433', 'OPTIONS': { 'DRIVER': 'SQL Server Native Client 11.0', }, } }

RossRogers commented 3 years ago

Your pyodbc connection needs to be debugged first. Iterate on installation step 3 until you have the correct parameters.