Tuesday, August 27, 2019

how to connect django with SQL Server ?

i have a django project that need to be connected with MS SQL Server . Iam using pyodbc package in order to make the connection but the problem is that once i try it it crash and 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 tried with both authentication mode 

this is the 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})


or 

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=no;'
                             'UID=SQLTest;'
                              'PWD=********;'                            )          cursor = conn.cursor()      c = cursor.execute('SELECT "first name" FROM Person   WHERE id = 2 ')        return render (request,'connect.html',{"c":c})

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/f2b220b3-be7a-47eb-a6ae-d4b040ef7cc1%40googlegroups.com.

No comments:

Post a Comment