Re: [42S22] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'p_comments'

2023-09-22 Thread Dimitris Kougioumtzis
I had the same problem Some ware in your code you loop the model that you want to make the changes so a solution is to comment the code temporally so you can proceed with your migrations On Friday, January 31, 2020 at 5:29:20 PM UTC+2 mahesh goud wrote: > Hi All, > > I am trying to add

Re: Facing Issue with ODBC Driver 17 for SQL Server

2023-02-10 Thread David Nugent
IIRC by default SQL Server runs each instance on its own port, and uses a broker (aka “browser service”) to determine which instance you are connecting to (on port 1434?). See this link for more info: https://learn.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-s

Re: python manage.py magrate gives the below error with SQL SERVER (Please help)

2021-08-10 Thread 'Amitesh Sahay' via Django users
check your database table though some UI. make sure that the " polls_question" is not there  On Tuesday, 10 August, 2021, 07:20:42 pm IST, Vikram Gajjala wrote: SQL Server 2019Python 3.9.6pip 21.2.3python -m django --version 3.2.6 asgiref              3.

python manage.py magrate gives the below error with SQL SERVER (Please help)

2021-08-10 Thread Vikram Gajjala
SQL Server 2019 Python 3.9.6 pip 21.2.3 python -m django --version 3.2.6 asgiref 3.4.1 astroid 2.6.6 colorama 0.4.4 Django 3.2.6 django-mssql-backend 2.8.1 django-pyodbc1.1.3 django-tastypie 0.14.3 isort5.9.3 lazy

Re: Connect Django with SQL Server 2012

2021-03-23 Thread Maurizio Faccin
Hi Kasper, thank you for your suggestion. I resolved deleting all the parameters in datase settings.py and I rewrite them. After that it works fine. I think I written samething wrong and I didn't able to find this error. Best regards, Maurizio Faccin Il 22/03/2021 17:05, Kasper Laudrup ha

Re: Connect Django with SQL Server 2012

2021-03-22 Thread Kasper Laudrup
On 22/03/2021 15.57, Maurizio Faccin wrote: > I tried to use the parameters above in a python script and works correctly. > > What I can do to resolve this issue? > I don't think I can solve the issue, but it might help if you post the relevant part of the Python script? Then someone might be

Connect Django with SQL Server 2012

2021-03-22 Thread Maurizio Faccin
Hello, I have a problem tryng to connect Django with a SQL Server 2012 runnig on my pc. I installed pyodb package and this is my connection parameters in settings.py DATABASES = {     'default': {     'ENGINE': "sql_server.pyodbc",     'NAME': "CD",

Re: Need Guidance to setup Django with MS SQL server

2020-10-11 Thread Dvs Khamele
r support for setting up my django project with MS SQL server. > > As there is no proper tutorial how to setup with MS SQL server. I tried it > many times but failed with same errors. Please help me to progress. > > Tried below : > 'ods_database': { > 'ENGINE': 'sql_server.py

Re: Need Guidance to setup Django with MS SQL server

2020-10-07 Thread Eugene TUYIZERE
th MS SQL server. > > As there is no proper tutorial how to setup with MS SQL server. I tried it > many times but failed with same errors. Please help me to progress. > > Tried below : > 'ods_database': { > 'ENGINE': 'sql_server.pyodbc', >

Need Guidance to setup Django with MS SQL server

2020-10-07 Thread arun sahu
Hi Geeks, I need your support for setting up my django project with MS SQL server. As there is no proper tutorial how to setup with MS SQL server. I tried it many times but failed with same errors. Please help me to progress. Tried below : 'ods_database': { 'ENGINE

Re: Unable to establish odbc connection to MS SQL Server

2020-04-27 Thread Darren Williams
ER': 'user', 'PASSWORD': 'password', 'HOST': 'DbHost', 'OPTIONS': { 'driver': 'ODBC Driver 13 for SQL Server', 'unicode_results': True, }, } } On Mon, Apr 27, 2020 at 10:22 PM Kirk Brown wrote: > I'm getting an error when I try to ru

Re: Unable to establish odbc connection to MS SQL Server

2020-04-27 Thread Gurmeet Kaur
': 'DbHost', 'OPTIONS': { 'driver': 'ODBC Driver 13 for SQL Server', 'unicode_results': True, }, } } On Mon, Apr 27, 2020 at 10:22 PM Kirk Brown wrote: > I'm getting an error when I try to runserver. Here is my code in manage.py: > >

Unable to establish odbc connection to MS SQL Server

2020-04-27 Thread Kirk Brown
': {'ODBC Driver 17 for SQL Server', } } } And here is the error: (venv) C:\Users\Kirk\PycharmProjects\PyShop>manage.py runserver Unhandled exception in thread started by .wrapper at 0x01770CD61438> Traceback (most recent call last): File "C:\Users\Kirk\Pych

Sql server and django

2020-03-24 Thread hajar Benjat
Hello django users I hope you are doing well! I want to connect my django application and makemigrations with sql server 2008. But I get some errors you can see below. I hope you can help me. Cordially -- You received this message because you are subscribed to the Google Groups "Django

Re: [42S22] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'p_comments'

2020-02-03 Thread mahesh goud
Yes I am using latest updates On Saturday, 1 February 2020 09:32:38 UTC+5:30, jlgimeno71 wrote: > > I know that SQL Server 2008 and 2012 had a regression that would issue > this error in some cases. Have you ensured you're using the latest > updates? I'm not sure what else to

how to connect django with SQL Server ?

2019-08-27 Thread leb dev
i have a django project that need to be connected with MS SQL Server . Iam using pyodbc package in order to make the connection but the problem is that once i try it it crash and display the below error : djago.db.utils.operationalError:('08001','[08001] [microsoft][odbc sql server driver

Establish a connection between django and SQL Server using pyodbc

2019-08-27 Thread leb dev
I have a django project that make a connection between django and SQL server the problem is that once the system run it display the below error: > djago.db.utils.operationalError:('08001','[08001] [microsoft][odbc sql > server driver]neither dsn nor server keyword suppl

Re: Connecting to SQL Server

2019-07-05 Thread Joe Reitman
>> Don't you need to assign a port number? >> >> On Wednesday, July 3, 2019 at 6:52:35 PM UTC-5, John Burke wrote: >>> >>> Trying to connect to SQL Server from Django >>> >>> DATABASES = { >>> 'default': { >>>

Re: Connecting to SQL Server

2019-07-04 Thread Adnan Sadzak
gt;> Jordan McKesson Principal >> >> 405-749-4550 ext. 309 >> >> jordan@epiccharterschools.org >> >> <http://facebook.com/epiccharterschools> >> <https://twitter.com/epiccharter> >> <https://www.instagram.c

Re: Connecting to SQL Server

2019-07-04 Thread John Burke
For this particular instance, I don't need the port number. On Thu, Jul 4, 2019 at 11:47 AM Joe Reitman wrote: > Don't you need to assign a port number? > > On Wednesday, July 3, 2019 at 6:52:35 PM UTC-5, John Burke wrote: >> >> Trying to connect to SQL Server from D

Re: Connecting to SQL Server

2019-07-04 Thread John Burke
rterschools.org > > <http://facebook.com/epiccharterschools> <https://twitter.com/epiccharter> > <https://www.instagram.com/epiccharterschools/> > <https://www.youtube.com/user/EpicCharterSchools> > > > > > On Wed, Jul 3, 2019 at 6:

Re: Connecting to SQL Server

2019-07-04 Thread Joe Reitman
Don't you need to assign a port number? On Wednesday, July 3, 2019 at 6:52:35 PM UTC-5, John Burke wrote: > > Trying to connect to SQL Server from Django > > DATABASES = { > 'default': { > 'ENGINE': 'sql_server.pyodbc', > 'NAME': 'dbname', >

Re: Connecting to SQL Server

2019-07-04 Thread Charlotte Wood
/www.youtube.com/user/EpicCharterSchools> On Wed, Jul 3, 2019 at 6:52 PM John Burke wrote: > Trying to connect to SQL Server from Django > > DATABASES = { > 'default': { > 'ENGINE': 'sql_server.pyodbc', > 'NAME': 'dbname', > 'HOST': 'hostname',

Connecting to SQL Server

2019-07-03 Thread John Burke
Trying to connect to SQL Server from Django DATABASES = { 'default': { 'ENGINE': 'sql_server.pyodbc', 'NAME': 'dbname', 'HOST': 'hostname', 'PORT': '', 'USER': 'user', 'PASSWORD': 'password', 'OPTIONS': { 'driver': 'ODBC

Connecting to SQL Server

2019-07-03 Thread John Burke
Getting the following error: File "...\venv\lib\site-packages\sql_server\pyodbc\base.py", line 362, in init_connection_state val = cursor.execute('SELECT SYSDATETIME()').fetchone()[0] ValueError: hour must be in 0..23 -- You received this message because you are subscribed to the Google

Django Project Using Azure App Services Not Connecting to Azure SQL Server Through Active Directory

2019-06-18 Thread Jorge William Pava Hernández
We are experiencing a problem with the Python connection to an Azure SQL Server, when trying to use the Active Directory as method for authentication. The error says that the user is blank and the domain name is malformed. Anyone having the same issue? -- You received this message because

Re: ms sql server connectivity to django

2019-01-07 Thread Ivan Martić
, 'AUTOCOMMIT': True, 'OPTIONS': { 'driver': 'ODBC Driver 17 for SQL Server', 'host_is_server': True, 'autocommit': True, 'driver_needs_utf8': True, 'use_legacy_date_fields' : True, }, } } You need to have pyodbc

Re: ms sql server connectivity to django

2019-01-07 Thread Ivan Martić
', #name of your table 'CONN_MAX_AGE': 0, 'AUTOCOMMIT': True, 'OPTIONS': { 'driver': 'ODBC Driver 17 for SQL Server', 'host_is_server': True, 'autocommit': True, 'driver_needs_utf8': True, 'use_legacy_date_fields

RE: ms sql server connectivity to django

2019-01-07 Thread pahlawanto.pancawindu
Make sure the port MSSQL is open. From: django-users@googlegroups.com On Behalf Of BALA KRISHNAN Sent: 07 January 2019 13:34 To: django-users@googlegroups.com Subject: Re: ms sql server connectivity to django Create your database in MySQL Migrate your files On Sun, 6 Jan 2019 at 23

Re: ms sql server connectivity to django

2019-01-07 Thread Jani Tiainen
Hi, What happens? Do you get errors? Nothing? On Sun, Jan 6, 2019 at 7:56 PM Praveen Kumar wrote: > Hi All, > > Changed DATABASE code as under in setting.py in Django project. But not > getting able to connect to MS SQL Server. Please suggest. > > ATABASES

Re: ms sql server connectivity to django

2019-01-06 Thread BALA KRISHNAN
Create your database in MySQL Migrate your files On Sun, 6 Jan 2019 at 23:25, Praveen Kumar wrote: > Hi All, > > Changed DATABASE code as under in setting.py in Django project. But not > getting able to connect to MS SQL Server. Please suggest. > > ATABASES

ms sql server connectivity to django

2019-01-06 Thread Praveen Kumar
Hi All, Changed DATABASE code as under in setting.py in Django project. But not getting able to connect to MS SQL Server. Please suggest. ATABASES = { 'default': { 'NAME': 'APJ_AIM_LITE', 'ENGINE': 'sqlserver_ado', 'HOST': 'DB_SERVER', 'USER

Re: Connecting Sql server to Django

2018-10-15 Thread Rakhee Menon
> Hey Vineeth, > > The last link which you gave worked like a pro..Thanks a lot for > it...Could you please help me out with one more issue... > As all my tables have been created in my old project I just want to access those tables using Django so without creating models how to access

Re: Connecting Sql server to Django

2018-10-15 Thread Rakhee Menon
Hey!VineethThanks a lot...It worked... -- 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 post to this group, send

Re: Connecting Sql server to Django

2018-10-14 Thread Pradeep Singh
gt; >> >> Hi Everyone, >> >> In my project I want to connect SQL Server 2014 with django, I tried with >> the given link, >> >>https://django-mssql.readthedocs.io/en/latest/quickstart.html >> >> but it shows some error like, >>

Re: Connecting Sql server to Django

2018-10-14 Thread sum abiut
://username:password@hostname /db') connection=engine.connect() hope this helps. On Fri, Oct 12, 2018 at 3:26 PM Rakhee Menon wrote: > > > Hi Everyone, > > In my project I want to connect SQL Server 2014 with django, I tried with > the given link, > >https://django-mssql.

Re: Connecting Sql server to Django

2018-10-14 Thread Gurmeet Kaur
Can you please share your settings.py file and requirements.txt? On Sun, Oct 14, 2018, 12:51 PM Pradeep Singh wrote: > please help me why i am getting no change detected > > On Sat, 13 Oct 2018 at 01:33, Gurmeet Kaur > wrote: > >> I did it in my project. Use pyodbc to

Re: Connecting Sql server to Django

2018-10-14 Thread Mateusz
..i have put the app name in setting.py .wait i will share all >>>> screen shot >>>> >>>> On Sun, 14 Oct 2018 at 22:34, vineeth sagar >>>> wrote: >>>> >>>>> Okay Did you put the app in installed_apps in settings.

Re: Connecting Sql server to Django

2018-10-14 Thread Pradeep Singh
apps in settings.py of your >>>> project? Also you are saying you're new to django why would you want to use >>>> a ms-sql server as the DB of you're choice? Not something as Postgres or >>>> mySQL which have good docs in the Django documentation. I think the above

Re: Connecting Sql server to Django

2018-10-14 Thread Mateusz
en >> shot >> >> On Sun, 14 Oct 2018 at 22:34, vineeth sagar > > wrote: >> >>> Okay Did you put the app in installed_apps in settings.py of your >>> project? Also you are saying you're new to django why would you want to use >>> a ms-sql

Re: Connecting Sql server to Django

2018-10-14 Thread Pradeep Singh
yes ..i have put the app name in setting.py .wait i will share all screen shot On Sun, 14 Oct 2018 at 22:34, vineeth sagar wrote: > Okay Did you put the app in installed_apps in settings.py of your project? > Also you are saying you're new to django why would you want to use a ms-sql &g

Re: Connecting Sql server to Django

2018-10-14 Thread vineeth sagar
Okay Did you put the app in installed_apps in settings.py of your project? Also you are saying you're new to django why would you want to use a ms-sql server as the DB of you're choice? Not something as Postgres or mySQL which have good docs in the Django documentation. I think the above fix

Re: Connecting Sql server to Django

2018-10-14 Thread Pradeep Singh
i am newbie in the django.. On Sun, 14 Oct 2018 at 22:21, Pradeep Singh wrote: > please help me why i am getting no change detected > > On Sat, 13 Oct 2018 at 01:33, Gurmeet Kaur > wrote: > >> I did it in my project. Use pyodbc to connect to sql server and i am

Re: Connecting Sql server to Django

2018-10-12 Thread Gurmeet Kaur
I did it in my project. Use pyodbc to connect to sql server and i am using django 2.0.8 On Fri, Oct 12, 2018, 11:04 AM Pradeep Singh wrote: > bro...will you help me ... > i am getting django 404 error ...please tell how to fix it... > i am using python 3.6 + django 1.11 > > On F

Re: Connecting Sql server to Django

2018-10-12 Thread Pradeep Singh
method to connect with sql server with newer > versions of django, also I think it's about time your company updated your > django version. For 2.1 the link I have given works seemlessly. > > > On Oct 12, 2018 5:38 PM, "Jason" wrote: > >> well, considering that 1.8 is no

Re: Connecting Sql server to Django

2018-10-12 Thread vineeth sagar
I don't know if it works for 1.8, you would've tested it by now. The link I haven given is a current method to connect with sql server with newer versions of django, also I think it's about time your company updated your django version. For 2.1 the link I have given works seemlessly. On Oct 12

Re: Connecting Sql server to Django

2018-10-12 Thread Jason
well, considering that 1.8 is no longer supported, you're not getting any backports and updates. which if you're doing a production level app, is pretty bad. Unfortunately, seems if you want to use the recent LTS or newer versions, SQL server is not an option unless you're willing to update

Re: Connecting Sql server to Django

2018-10-12 Thread Rakhee Menon
Hi Vineeth, Just had to make some changes in an old project which uses Sql Server 2014 and yeah I am using django 1.8. Is it that for the link you have given should I use Django 2.1 version or 1.8would work??? Thanks Rakhee -- You received this message because you are subscribed

Re: Connecting Sql server to Django

2018-10-11 Thread vineeth sagar
have explained you. Apart from that I was forced to use ms-sql at work, what's your reason to use SQL server? regards Vineeth On Oct 12, 2018 9:56 AM, "Rakhee Menon" wrote: > > > Hi Everyone, > > In my project I want to connect SQL Server 2014 with django, I tr

Connecting Sql server to Django

2018-10-11 Thread Rakhee Menon
Hi Everyone, In my project I want to connect SQL Server 2014 with django, I tried with the given link, https://django-mssql.readthedocs.io/en/latest/quickstart.html but it shows some error like, import pythoncom ImportError: No module named 'pythoncom

Re: Configuration settings for Sql Server database in django

2018-10-10 Thread Rakhee Menon
Hi Vinod, Thanks for the quick response ...I also had doubt regarding which version of python and django are supported for SQL Server 2014. Thanks -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this grou

Re: Configuration settings for Sql Server database in django

2018-10-10 Thread 'Vinod Kumar' via Django users
iguration settings to be done > in Django for using SQL Server 2014 as database instead of the default > sqlite. > > Thanks in Advance > Rakhee > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsu

Configuration settings for Sql Server database in django

2018-10-10 Thread Rakhee Menon
Hello Everyone, Please could anyone specify what are the configuration settings to be done in Django for using SQL Server 2014 as database instead of the default sqlite. Thanks in Advance Rakhee -- You received this message because you are subscribed to the Google Groups "Django

Re: Change sqlite database to sql server

2018-10-09 Thread Jason
the error is saying your remote server doesn't allow external connections, so look at the docs for how to enable that -- 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

Re: Change sqlite database to sql server

2018-10-09 Thread Rakhee Menon
11 for SQL Server]Login timeout expired (0); [08001] [Microsoft][ODBC Driver 11 for SQL Server]Invalid connection string attribute (0); [08001] [Microsoft][ODBC Driver 11 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server

Re: Change sqlite database to sql server

2018-10-07 Thread Vishvajit Pathak
Hi Rakhee, Two possible reasons for this error : A) ODBC driver is not installed B) The driver requires a Data Source Name to be configured You can refer these links for more explanation :

Re: Change sqlite database to sql server

2018-10-07 Thread Jason
You might have some trouble with SQL Server http://nightlyclosures.com/2018/01/08/working-with-mssql-in-django/ but sounds to me you haven't installed the driver or anything else for django to talk to SQL server. have you insalled https://bitbucket.org/Manfre/django-mssql or any

Change sqlite database to sql server

2018-10-07 Thread Rakhee Menon
Hi everyone, I have a developed project in which I am trying to use sqlserver instead of the default sqlite database. While I do the changes I get the following error django.db.utils.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default

Re: Sql server

2018-09-30 Thread Vishvajit Pathak
me, first I need to change the names of the auth tables of Django to follow > the standard of company names, second I need to create the security tables > in a custom schema in SQL Server, does anyone have any tips? > -- You received this message because you are subscribed to the Goog

Re: Sql Server

2018-09-27 Thread Elton Oliveira
setembro de 2018 12:37:44 UTC-4, Pardhu Saradhi escreveu: > > Can you please msg me what you have done > > On Thu 27 Sep, 2018, 5:05 AM Elton Oliveira, > wrote: > >> Hello guys, how do I create my tables in other SQL server schemas? OBS: I >> tried everything an

Re: Sql Server

2018-09-27 Thread Pardhu Saradhi
Can you please msg me what you have done On Thu 27 Sep, 2018, 5:05 AM Elton Oliveira, wrote: > Hello guys, how do I create my tables in other SQL server schemas? OBS: I > tried everything and I could not > > -- > You received this message because you are subscribed to th

Re: Sql server

2018-09-27 Thread Jason
kl 01:35 skrev Elton Oliveira > >: >> >>> Hello guys, I'm having two difficulties and I wonder if anyone can help >>> me, first I need to change the names of the auth tables of Django to follow >>> the standard of company names, second I need to create the sec

Re: Sql server

2018-09-27 Thread Elton Oliveira
ompany names, second I need to create the security tables >> in a custom schema in SQL Server, does anyone have any tips? >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To unsubscribe f

Re: Sql server

2018-09-27 Thread Andréas Kühne
ficulties and I wonder if anyone can help > me, first I need to change the names of the auth tables of Django to follow > the standard of company names, second I need to create the security tables > in a custom schema in SQL Server, does anyone have any tips? > > -- > You receiv

Sql server

2018-09-26 Thread Elton Oliveira
Hello guys, I'm having two difficulties and I wonder if anyone can help me, first I need to change the names of the auth tables of Django to follow the standard of company names, second I need to create the security tables in a custom schema in SQL Server, does anyone have any tips? -- You

Sql Server

2018-09-26 Thread Elton Oliveira
Hello guys, how do I create my tables in other SQL server schemas? OBS: I tried everything and I could not -- 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, sen

Re: Not able to connect to SQL Server 2012 from current version of DJango and Python

2018-08-11 Thread Jason
the dev for that library has specified that this is not compatible with django 2.1. so your options are to either find another connector library compatible with 2.1 or downgrade to using 2.0.x https://github.com/michiya/django-pyodbc-azure/blob/azure-2.0/setup.py#L29 > -- You received this

Not able to connect to SQL Server 2012 from current version of DJango and Python

2018-08-10 Thread Gurmeet Kaur
Hi All, I am trying to connect to SQL server 2012 using Pyodbc and DJango framework but the version of Django is 2.1. Now, when I try to connect using below code when I only have Pyodbc installed then the below code doesnot run. DATABASES = { 'default': { # 'ENGINE': '{ODBC Driver 11

Re: Need help for DJango on Windows server with MS SQL Server 2012

2018-07-12 Thread Jason
be answered by doing proper research and investigation, both beforehand as well as during update problems. On Wednesday, July 11, 2018 at 6:08:58 PM UTC-4, gurmeetka...@gmail.com wrote: > > Hi All, > > Me and my team will be developing our first application in Python and we > will be u

Need help for DJango on Windows server with MS SQL Server 2012

2018-07-11 Thread gurmeetkaurjuneja23
Hi All, Me and my team will be developing our first application in Python and we will be using SQL Server as backend. I wanted to ask one query regarding the versions of Python that have been developed and the ones that are in development. If we use the current available version of the Python

Re: How to fetch data from sql server and display on django web pages

2018-02-13 Thread PASCUAL Eric
, 2018 10:24:07 PM To: django-users@googlegroups.com Subject: Re: How to fetch data from sql server and display on django web pages You may want to check out sqlalchemy they provide a pretty good documentation on what you are aftering http://docs.sqlalchemy.org/en/latest/dialects/mssql.html >

Re: How to fetch data from sql server and display on django web pages

2018-02-12 Thread sum abiut
tmt).fetchall() return render(request,'template.html',locals()) then you can pass the results to your template.html Hope this helps. Cheers On Sun, Feb 11, 2018 at 4:37 PM, Amit Kadivar <amit.kadiv...@gmail.com> wrote: > Please Help me. > How to fetch data from sql server and display

Re: How to fetch data from sql server and display on django web pages

2018-02-11 Thread carlos
ango-users@googlegroups.com <django-users@googlegroups.com> on > behalf of Amit Kadivar <amit.kadiv...@gmail.com> > *Sent:* Sunday, February 11, 2018 6:37:28 AM > *To:* Django users > *Subject:* How to fetch data from sql server and display on django web > pages > > Pleas

Re: How to fetch data from sql server and display on django web pages

2018-02-11 Thread PASCUAL Eric
;django-users@googlegroups.com> on behalf of Amit Kadivar <amit.kadiv...@gmail.com> Sent: Sunday, February 11, 2018 6:37:28 AM To: Django users Subject: How to fetch data from sql server and display on django web pages Please Help me. How to fetch data from sql server and display them on dj

How to fetch data from sql server and display on django web pages

2018-02-10 Thread Amit Kadivar
Please Help me. How to fetch data from sql server and display them on django web pages through nginx web server.. -- 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, sen

Re: Connection with SQL server and user registration form

2017-08-28 Thread Vineet Kothari
17, at 3:25 PM, Gopi Devarapalli <devarapalli.go...@gmail.com> > wrote: > > Hi everyone, > > I am new to django. I just want to connect with sql server. And when user > submit the form i need to save the details on the sql server database > table. And I am confusing

Re: Connection with SQL server and user registration form

2017-08-28 Thread yingi keme
lli <devarapalli.go...@gmail.com> > wrote: > > Hi everyone, > > I am new to django. I just want to connect with sql server. And when user > submit the form i need to save the details on the sql server database table. > And I am confusing that there ar

Connection with SQL server and user registration form

2017-08-28 Thread Gopi Devarapalli
Hi everyone, I am new to django. I just want to connect with sql server. And when user submit the form i need to save the details on the sql server database table. And I am confusing that there are models that are using SQLite, is it mandatory to use Model? -- You received this message

Connect to SQL server but error when migrations

2017-03-20 Thread max
I have the following question post on stackoverflow <http://stackoverflow.com/questions/42903810/connect-to-sql-server-using-djangopyodbc>, but no one can answer me. Hope anyone who has experience on it, I appreciate it! -- You received this message because you are subscribed to the

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

2016-08-11 Thread Constantine Covtushenko
Great job done. You welcome! Regards, On Thu, Aug 11, 2016 at 8:46 PM, Evan Roberts wrote: > > Thanks for the help and guidance. I found a solution. I installed these > libs and was able to connect: > Django (1.9.9) > django-pyodbc-azure (1.9.9.0) > pip (8.1.2) >

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

2016-08-11 Thread Evan Roberts
Thanks for the help and guidance. I found a solution. I installed these libs and was able to connect: Django (1.9.9) django-pyodbc-azure (1.9.9.0) pip (8.1.2) pyodbc (3.0.10) I connected using these settings: DATABASES = { 'default': { 'ENGINE': 'sql_server.pyodbc', 'HOST':

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

2016-08-11 Thread Evan Roberts
yright", "credits" or "license" for more information. >>> import pyodbc >>> cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=***;PORT=1433;DATABASE=my_db;UID=*;PWD=*') >>> cursor = cnxn.cursor() >>> cursor.execute("select name,s

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

2016-08-11 Thread Evan Roberts
> > Hi Mike, Thanks for the suggestion. Yes, postgres would be a good answer, but not really a possibility at this point. Let me give you the back ground. I inherited this project. The original project is written using django 0.95 and SQL Server 2003. The project that was w

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

2016-08-11 Thread John Fabiani
python and django. >> >> Is django_pyodbc supported on Python 3.5.1 and django 1.9? If not could >> you suggest a combination of python & django that is known to work with >> MS SQL Server 2012? >> > > Not an answer to your specific question but a recommendation to use >

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

2016-08-10 Thread Mike Dewhirst
On 11/08/2016 5:11 AM, Evan Roberts wrote: I'm struggling to get a project going. I'm new to python and django. Is django_pyodbc supported on Python 3.5.1 and django 1.9? If not could you suggest a combination of python & django that is known to work with MS SQL Server 2012? Not an an

Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

2016-08-10 Thread Evan Roberts
I'm struggling to get a project going. I'm new to python and django. Is django_pyodbc supported on Python 3.5.1 and django 1.9? If not could you suggest a combination of python & django that is known to work with MS SQL Server 2012? Here are the details of my virtual environment windo

Django and SQL Server

2016-07-04 Thread Massimo Barbierato
Hi everybody. I have a little problem with SQL Server. I'm using django-pyodbc as db backend but when i run inspectdb it occurs an error because some of the tables in the SQL Server database have unicode chars (an example: the table name is 'Attività'). How can I resolve that? I can't change

Re: Djnago 1.9.5 with SQL SERVER 2012 connect??

2016-05-14 Thread Mandeep Tondak
#Try using 'django.db.backends.XXX', where XXX is one > of: 'mysql', 'oracle', 'postgresql', 'sqlite3' > > 3. 'ENGINE': 'sql_server.pyodbc' > django.db.utils.ProgrammingError: ('42000', "[42000] > [unixODBC][FreeTDS][SQL Server]Login failed for user 'mandeep'. (18456) > (SQLDriv

Re: Djnago 1.9.5 with SQL SERVER 2012 connect??

2016-05-13 Thread Nikolas Stevenson-Molnar
> Showing me Error: Django 1.9 is not supported. > > 2.'ENGINE': 'sqlserver_ado', > showing me error:- #Try using 'django.db.backends.XXX', where XXX is one of: > 'mysql', 'oracle', 'postgresql', 'sqlite3' > > 3. 'ENGINE': 'sql_server.pyodbc' > django.db.utils.Programm

Djnago 1.9.5 with SQL SERVER 2012 connect??

2016-05-13 Thread mandeep444
', showing me error:- #Try using 'django.db.backends.XXX', where XXX is one of: 'mysql', 'oracle', 'postgresql', 'sqlite3' 3. 'ENGINE': 'sql_server.pyodbc' django.db.utils.ProgrammingError: ('42000', "[42000] [unixODBC][FreeTDS][SQL Server]Login failed for user 'mandeep'. (18456) (SQLDriverCo

Re: Using Django with Microsoft SQL Server

2016-01-07 Thread whycrying
Sorry. `inspect` -> `inspectdb` . On Fri, Jan 8, 2016 at 12:54 AM, whycrying <kwanw...@gmail.com> wrote: > Using django-pyodbc for connecting to SQL Server as Sid said. > > Then use the `inspect` management command to build the models :: > > $ python manage.py inspe

Re: Using Django with Microsoft SQL Server

2016-01-07 Thread Sid
int me to documentation on > how to connect an existing SQL Server database to a new Django app? > > How would the models be built from it? > > Thanks, > > Gerry > > > > > > > > The information t

Using Django with Microsoft SQL Server

2016-01-07 Thread Gerry Seidl
Can someone please provide me the details, or point me to documentation on how to connect an existing SQL Server database to a new Django app? How would the models be built from it? Thanks, Gerry The information transmitted

Re: Microsoft SQL Server and Azure SQL Database support

2015-05-21 Thread Michael Manfre
django-pyodbc-azure might be a better choice and it seems to be more actively maintained. On Thursday, May 21, 2015 at 8:30:33 AM UTC-4, felix wrote: > > El 20/05/15 14:39, Meet Bhagdev escribió: > > When I last checked the Django ORM did not have official support for SQL > S

Re: Microsoft SQL Server and Azure SQL Database support

2015-05-21 Thread felix
El 20/05/15 14:39, Meet Bhagdev escribió: When I last checked the Django ORM did not have official support for SQL Server and Azure SQL DB. Is there a way to use SQL Server and more importantly Azure SQL DB by modifying the DATABASES configuration in settings.py Try django-pyodbc. On Linux

Microsoft SQL Server and Azure SQL Database support

2015-05-20 Thread Meet Bhagdev
When I last checked the Django ORM did not have official support for SQL Server and Azure SQL DB. Is there a way to use SQL Server and more importantly Azure SQL DB by modifying the DATABASES configuration in settings.py -- You received this message because you are subscribed to the Google

Re: SQL Server Support - Does it Exist

2015-04-29 Thread Alex-droid AD
We try to use django-pyodbc on CentOS (python 2.7 + Django 1.8, connection to MS SQL Server 2012) While running 'migrare' I get the same error as mentioned above: 'django_pyodbc' isn't an available database backend Can't understand what has been done wrong... On Sunday, March 24, 2013 at 5:14

Re: SQL Server performance problem

2015-01-28 Thread chj
Avoid using ODBC. It's horribly slow. While I have no experience with MSSQL, you may have a look at django-mssql: https://django-mssql.readthedocs.org/ -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop

SQL Server performance problem

2015-01-28 Thread Fred
I'm on a W7 32bit virtual machine with python 2.7 and SQL Server 2008 with local views referencing Linked Server where the real data resides. My setup is Django (1.7.4) django-pyodbc (0.2.6) django-pyodbc-azure (1.2.3) not using this, it was a false start that did not pan out

Re: Porting to Django Linux with SQL Server Backend

2014-10-16 Thread robert brook
g any of the >>> specific errors you encountered, but django-mssql only works on Windows. >>> Depending on the error you encountered with pymssql, you could try >>> django-pymssql (https://github.com/aaugustin/django-pymssql). >>> >>> Regards, >>

  1   2   3   >