yes i am on the same LAN and i am able to get remote connection and ping
--
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
Yes it is right . r u on same LAN?
From: django-users@googlegroups.com [mailto:django-users@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
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
Make sure that port is opened and it is reachable from machine u r trying to
access
From: django-users@googlegroups.com [mailto:django-users@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
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
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'*: {
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',
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
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':
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
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
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)
11 matches
Mail list logo
