Establish a connection between django and SQL Server using pyodbc

13 views
Skip to first unread message

leb dev

unread,
Aug 27, 2019, 10:47:14 AM8/27/19
to Django users
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 %}
Reply all
Reply to author
Forward
0 new messages