help me to fix this issue with database connection
leb dev
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})
Amitesh Sahay
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...@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.
leb dev
Amitesh Sahay
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql',
'NAME': 'Authenticate', # database name
'USER': 'postgres',
'PASSWORD': 'pwd',
'HOST': 'localhost'
}
}On Thursday, August 29, 2019 at 8:34:17 AM UTC+3, leb dev 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})
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit
doddahulugappa
Pip install pyodbc
And add below code snipped in settings.py. it should work. I am using in this way. It works perfectly
DATABASES = {
'default': {
'ENGINE': 'sql_server.pyodbc'
,
'NAME': 'DB',
'USER': 'user',
'PASSWORD': 'pwd’,
'HOST': 'host',
'PORT': 'port',
'OPTIONS': {
'driver': 'ODBC Driver 17 for SQL Server',
'isolation_level': 'READ UNCOMMITTED', # prevent SELECT deadlocks
},
}
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/1697008900.237063.1567066571422%40mail.yahoo.com.
leb dev
And add below code in settings.py.
DATABASES = {
'default': {
'ENGINE': 'sql_server.pyodbc',
'NAME': 'DB',
'USER': 'user',
'PASSWORD': 'pwd’,
'HOST': 'host',
'OPTIONS': {
'driver': 'ODBC Driver 17 for SQL Server',
},
}
To unsubscribe from this group and stop receiving emails from it, send an email to django...@googlegroups.com.
To view this discussion on the web visit
--
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...@googlegroups.com.
leb dev
doddahulugappa
Make sure that port is opened and it is reachable from machine u r trying to access
From: django...@googlegroups.com [mailto:django...@googlegroups.com] On Behalf Of leb dev
Sent: Thursday, August 29, 2019 12:33 PM
To: Django users
Subject: Re: help me to fix this issue with database connection
i tried your answer also and did not work i do not know what is the problem and how to fix it
--
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/28dc899d-d6e5-4767-b3a1-bec89e6e5248%40googlegroups.com.
leb dev
isn't this right ?
doddahulugappa
Yes it is right . r u on same LAN?
From: django...@googlegroups.com [mailto:django...@googlegroups.com] On Behalf Of leb dev
Sent: Thursday, August 29, 2019 1:47 PM
To: Django users
Subject: Re: help me to fix this issue with database connection
yes i can get a remote connection with the server and i can do ping so its reachable.
and about the port its the default port used to connect ms sql server 1433.
isn't this right ?
--
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/cd42cf20-4abd-49db-a581-df7aa7a61ef5%40googlegroups.com.