I have a django project that make a connection between django and SQL server the problem is that once the system run it display the below error:
> djago.db.utils.operationalError:('08001','[08001] [microsoft][odbc sql
> server driver]neither dsn nor server keyword supplied (0)
> (sqldriverconnect); [08001] [microsoft][odbc sql server driver]
> Invalid connection string attribute (0)')
I know that the code 08001 mean *Client unable to establish connection*
But all the credentials are correct. What am I missing here?
views.py
from django.shortcuts import render
import pyodbc
def connect(request):
conn = pyodbc.connect(
'Driver={SQL Server};'
'Server=ip address;'
'Database=I-Base_beSQL;'
'Trusted_Connection=yes;'
)
cursor = conn.cursor()
c = cursor.execute('SELECT "first name" FROM Person WHERE id = 2 ')
return render (request,'connect.html',{"c":c})
connect.html
{% for row in c %}
{{ row }}
{% endfor %}