i already installed pyodbc package.
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'*,
},
}
}
On Thursday, August 29, 2019 at 11:22:35 AM UTC+3, doddahulugappa wrote:
>
>
>
> 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 *},
> }
>
> }
>
>
>
>
>
> *From:* 'Amitesh Sahay' via Django users [mailto:
> django...@googlegroups.com <javascript:>]
> *Sent:* Thursday, August 29, 2019 12:16 PM
> *To:* Django users
> *Subject:* Re: help me to fix this issue with database connection
>
>
>
> DATABASES = {
> 'default': {
> 'ENGINE': 'django.db.backends.postgresql',
> 'NAME': 'Authenticate', # database name
> 'USER': 'postgres',
> 'PASSWORD': 'pwd',
> 'HOST': 'localhost'
> }
> }
>
> I don't think you need anything other than this. For MySql you can use
> mysql driver "*django*.*db*.*backends*.*mysql*". I hope that works.
>
>
>
> Regards,
>
> Amitesh Sahay
>
>
>
>
>
> On Thursday, 29 August, 2019, 01:41:44 pm IST, leb dev <testd...@gmail.com
> <javascript:>> wrote:
>
>
>
>
>
> i tried in the settings.py
>
> DATABASES = {
>
> 'default': {
>
> 'ENGINE': 'sql_server.pyodbc',
>
> 'NAME': 'testDB',
>
> 'HOST': 'VSQLSERV',
>
> 'OPTIONS': {
>
> 'driver':' SQL Server',
>
> }
>
>
>
> # 'ENGINE': 'django.db.backends.sqlite3',
>
> # 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
>
> }
>
> }
>
>
> 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})
>
> --
> 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 <javascript:>.
> To view this discussion on the web visit
>
>
> https://groups.google.com/d/msgid/django-users/a1cdc16f-4cb0-4d47-872c-7c9320023263%40googlegroups.com
>
> <https://groups.google.com/d/msgid/django-users/a1cdc16f-4cb0-4d47-872c-7c9320023263%40googlegroups.com?utm_medium=email&utm_source=footer>
>
> .
>
> --
> 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 <javascript:>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/1697008900.237063.1567066571422%40mail.yahoo.com
>
> <https://groups.google.com/d/msgid/django-users/1697008900.237063.1567066571422%40mail.yahoo.com?utm_medium=email&utm_source=footer>
> .
>
--
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/39fc2138-1168-4d7a-b55c-823df8e72010%40googlegroups.com.
