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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/a1cdc16f-4cb0-4d47-872c-7c9320023263%40googlegroups.com.
