My friend, why don't you use settings.py for Db connection?
Regards,
Amitesh Sahay91-750 797 8619
On Thursday, 29 August, 2019, 11:04:57 am IST, leb dev
<testdev...@gmail.com> wrote:
i have a django project that need to be connected to MS SQL Server i am using
pyodbc package.
once i run the program the system 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)')
where is the error and how to fix it ?
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})
--
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/4bdca932-9293-409e-a144-ef535d138422%40googlegroups.com.
--
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/1060976984.192183.1567062246533%40mail.yahoo.com.
