MSSQL server database question

2021-10-14 Thread hebers
Greetings. I was given a task of creating a django app that will use a database. However, I am not given admin rights to create a database on MSSQL Server, and I can only create tables inside an assigned database with existing tables. I have tried migrations on an existing database (py

Re: Error while trying to connect latest Dango with MSSQL

2019-09-26 Thread challa.Harikrishna chowdary
go with ur \AppData\Local\Programs\Python\Python37-32\Lib\site-packages\django\db\backends\mysql change the base and introspeciton to MysqlDB to pymysql On Tuesday, September 24, 2019 at 9:06:01 AM UTC+5:30, Praveen Kumar wrote: > > Please find blow the error I'm receiving > > Traceback (most

Re: Error while trying to connect latest Dango with MSSQL

2019-09-23 Thread Praveen Kumar
Please find blow the error I'm receiving Traceback (most recent call last): File "C:\ProgramData\Anaconda3\lib\threading.py

Re: Error while trying to connect latest Dango with MSSQL

2019-09-17 Thread 'Amitesh Sahay' via Django users
What is the error message? If the subject line you are talking about, its very generic. please be specific. Regards, Amitesh On Wednesday, 18 September, 2019, 02:06:03 am IST, Praveen Kumar wrote: Hi All, Just I have updated the latest version of Dango. But now I'm getting error m

Error while trying to connect latest Dango with MSSQL

2019-09-17 Thread Praveen Kumar
Hi All, Just I have updated the latest version of Dango. But now I'm getting error message. Please suggest me. -- 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

Re: How to inspect MSSQL Database in Django 2.1

2019-09-12 Thread Adam Parsons
(with your passwords, secrets, etc edited out) 2. The command exactly as you are entering it 3. The output you're receiving. If you aren't receiving any output, please post the contents of the models.py file you're outputting to In the meantime, its worth checking out

How to inspect MSSQL Database in Django 2.1

2019-09-11 Thread wikils john
I have a large MSSQL server. I am using it now. I am going to use this database in new django project. however, inspectdb TableName > models.py this command isn't performed. How can I fix this? -- You received this message because you are subscribed to the Google Groups "Django use

Re: Django login implement using exisit mssql (MD5 hash password encode).

2017-03-17 Thread ludovic coues
t; > 2017-03-17 10:47 GMT+01:00 : >> >> I am a starter of Django. >> I want to get my user profile(login_name and password) to login. >> 1.How to encode the password and compare the password in mssql db using >> MD5 ? >> 2.How to implement login required withou

Re: Django login implement using exisit mssql (MD5 hash password encode).

2017-03-17 Thread Andréas Kühne
ault/#auth-web-requests Regards, Andréas 2017-03-17 10:47 GMT+01:00 : > I am a starter of Django. > I want to get my user profile(login_name and password) to login. > 1.How to encode the password and compare the password in mssql db using > *MD5* ? > 2.How to implement login requ

Django login implement using exisit mssql (MD5 hash password encode).

2017-03-17 Thread guoya
I am a starter of Django. I want to get my user profile(login_name and password) to login. 1.How to encode the password and compare the password in mssql db using *MD5* ? 2.How to implement login required without using Django build-in *login_required *? *forms.py* class LoginForm(forms.Form

Re: connecting to mssql database

2016-08-18 Thread sum abiut
> >> I am getting the error mes >> >> django.db.utils.Error: ('IM002', '[IM002] [unixODBC][Driver Manager]Data >> source name not found, and no default driver specified (0) >> (SQLDriverConnect)')sage >> >> >> >> >

Re: connecting to mssql database

2016-08-17 Thread sum abiut
mes > > django.db.utils.Error: ('IM002', '[IM002] [unixODBC][Driver Manager]Data > source name not found, and no default driver specified (0) > (SQLDriverConnect)')sage > > > > > On Wed, Aug 17, 2016 at 11:17 PM, Daniel França > wrote: > >&g

Re: connecting to mssql database

2016-08-17 Thread sum abiut
ing? > > On Wed, 17 Aug 2016 at 14:15 sum abiut wrote: > >> >> Hi, >> i am having a very hard time figuring out how to connect to a mssql >> database. i've try following this guide but nothing seems to be working. >> please help >> >>

Re: connecting to mssql database

2016-08-17 Thread Daniel França
What errors are you getting? On Wed, 17 Aug 2016 at 14:15 sum abiut wrote: > > Hi, > i am having a very hard time figuring out how to connect to a mssql > database. i've try following this guide but nothing seems to be working. > please help > > http://www.tivix.com/b

connecting to mssql database

2016-08-17 Thread sum abiut
Hi, i am having a very hard time figuring out how to connect to a mssql database. i've try following this guide but nothing seems to be working. please help http://www.tivix.com/blog/getting-django-working-with-mssql-pyodbc/ https://pypi.python.org/pypi/django-pyodbc-azure cheers, --

Re: mssql databASE CONNECTION to Django

2015-11-05 Thread Collin Anderson
Hello, I'd recommend using django 1.7 until mssql gets compatible with django 1.8. Thanks, Collin On Friday, October 30, 2015 at 3:31:35 PM UTC+1, Sid wrote: > > sorry tim I know I am asking a dumb question...can you please tell me what > is the best way to make it work ple

Re: mssql databASE CONNECTION to Django

2015-10-30 Thread Sid
np...but thanks for your time -- 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 email to dja

Re: mssql databASE CONNECTION to Django

2015-10-30 Thread Tim Graham
Sorry, I haven't used the library myself and can't provide any additional help. On Friday, October 30, 2015 at 10:31:35 AM UTC-4, Sid wrote: > > sorry tim I know I am asking a dumb question...can you please tell me what > is the best way to make it work please if possibe...because I am struck >

Re: mssql databASE CONNECTION to Django

2015-10-30 Thread Sid
sorry tim I know I am asking a dumb question...can you please tell me what is the best way to make it work please if possibe...because I am struck form last 2 days -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group

Re: mssql databASE CONNECTION to Django

2015-10-30 Thread Tim Graham
Please read the documentation: https://django-mssql.readthedocs.org/en/latest/quickstart.html On Friday, October 30, 2015 at 9:53:42 AM UTC-4, Sid wrote: > > so which version will be compatible... > > On Friday, October 30, 2015 at 7:54:26 AM UTC-4, Tim Graham wrote: >> >&

Re: mssql databASE CONNECTION to Django

2015-10-30 Thread Sid
so which version will be compatible... On Friday, October 30, 2015 at 7:54:26 AM UTC-4, Tim Graham wrote: > > django-mssql doesn't support Django 1.8 yet: > > https://django-mssql.readthedocs.org/en/latest/changelog.html > > On Thursday, October 29, 2015 at 9:36:38 PM UTC-

Re: mssql databASE CONNECTION to Django

2015-10-30 Thread Tim Graham
django-mssql doesn't support Django 1.8 yet: https://django-mssql.readthedocs.org/en/latest/changelog.html On Thursday, October 29, 2015 at 9:36:38 PM UTC-4, Sid wrote: > > *Hi all,* > I am trying to connect database which is in server to django, but it is > showing many error

mssql databASE CONNECTION to Django

2015-10-29 Thread Sid
*Hi all,* I am trying to connect database which is in server to django, but it is showing many errors like(platform i am using M visual studio) *Traceback (most recent call last):* File "C:\Users\speesary\Desktop\programs\learn\learn\manage.py", line 17, in execute_from_command_line(sys.a

Re: Django-mssql repo has switched to Git

2014-11-14 Thread pythonista
Django-mssql. The project has shifted from Hg > to Git (still on Bitbucket). For most people, this will have no impact. If > any of you had a dependency to a specific changeset, you will need to > update the reference to use Git instead of Hg. > > I've been using Git dail

Re: Django-mssql repo has switched to Git

2014-11-14 Thread Larry Martell
On Fri, Nov 14, 2014 at 9:36 PM, Michael Manfre wrote: > A heads up to anyone using Django-mssql. The project has shifted from Hg to > Git (still on Bitbucket). For most people, this will have no impact. If any > of you had a dependency to a specific changeset, you will need to u

Django-mssql repo has switched to Git

2014-11-14 Thread Michael Manfre
A heads up to anyone using Django-mssql. The project has shifted from Hg to Git (still on Bitbucket). For most people, this will have no impact. If any of you had a dependency to a specific changeset, you will need to update the reference to use Git instead of Hg. I've been using Git daily

Re: trying to configure MSSQL 2012 as backend with Django.

2014-06-17 Thread sarfaraz ahmed
ver_ado', >>> 'HOST': ' ', >>> 'USER': 'sa', >>> 'PASSWORD': '*', >>> } >>> } >>> I am new to DJANGO... >>> >>> Regards,

Re: trying to configure MSSQL 2012 as backend with Django.

2014-06-16 Thread Michael Manfre
x27;PASSWORD': '*', >>> } >>> } >>> I am new to DJANGO... >>> >>> Regards, >>> Sarfaraz Ahmed >>> >>> >>> On Mon, Jun 16, 2014 at 12:57 AM, Mark Phillips < >>> ma...@phillipsmarketin

Re: trying to configure MSSQL 2012 as backend with Django.

2014-06-15 Thread Ezequiel Bertti
ds, >> Sarfaraz Ahmed >> >> >> On Mon, Jun 16, 2014 at 12:57 AM, Mark Phillips < >> m...@phillipsmarketing.biz> wrote: >> >>> Did you look here?? >>> >>> http://django-mssql.readthedocs.org/en/latest/ >>> >>> Mar

Re: trying to configure MSSQL 2012 as backend with Django.

2014-06-15 Thread sarfaraz ahmed
p://django-mssql.readthedocs.org/en/latest/ >> >> Mark >> >> >> On Sun, Jun 15, 2014 at 11:35 AM, sarfaraz ahmed >> wrote: >> >>> Hello Friends, >>> >>> I am trying to moving away from sqlite. Trying to use MS SQl 2012 as >>

Re: trying to configure MSSQL 2012 as backend with Django.

2014-06-15 Thread sarfaraz ahmed
k here?? > > http://django-mssql.readthedocs.org/en/latest/ > > Mark > > > On Sun, Jun 15, 2014 at 11:35 AM, sarfaraz ahmed > wrote: > >> Hello Friends, >> >> I am trying to moving away from sqlite. Trying to use MS SQl 2012 as >> backend. So far I ins

Re: trying to configure MSSQL 2012 as backend with Django.

2014-06-15 Thread Mark Phillips
Did you look here?? http://django-mssql.readthedocs.org/en/latest/ Mark On Sun, Jun 15, 2014 at 11:35 AM, sarfaraz ahmed wrote: > Hello Friends, > > I am trying to moving away from sqlite. Trying to use MS SQl 2012 as > backend. So far I installed django-mssql on my machine.

trying to configure MSSQL 2012 as backend with Django.

2014-06-15 Thread sarfaraz ahmed
Hello Friends, I am trying to moving away from sqlite. Trying to use MS SQl 2012 as backend. So far I installed django-mssql on my machine. When I type import sqlserver_ado... It works fine. I am new to Django. Please provide me with example to get my MSSQL connected to django. More than one

Re: WebPage with MsSql access

2012-10-17 Thread Tom Evans
On Wed, Oct 17, 2012 at 10:34 AM, Markus Christen wrote: > Hi all > I have to make a WebPage with Django. It must be possible to connect from > the page to the mssql database. i have an odbc program know atm, and this > works... > - > import pyodbc > > cnxn = pyo

WebPage with MsSql access

2012-10-17 Thread Markus Christen
Hi all I have to make a WebPage with Django. It must be possible to connect from the page to the mssql database. i have an odbc program know atm, and this works... - import pyodbc cnxn = pyodbc.connect('DRIVER={SQL Server}; SERVER=MAURITIUS;DATABASE=baan5c;UID=portal;PWD=P0rtalR

Re: inspectdb() sees MSSQL varchar([n]) fields as type textfield

2012-06-13 Thread rico_suave
elatively new to Django and currently implementing a > > system where we use inspectdb to use an existing MSSQL 2005 database from > > within Django. > > We have encountered different problems with the ORM part of the application > > in combination with MSSQL, most of which we

Re: inspectdb() sees MSSQL varchar([n]) fields as type textfield

2012-06-11 Thread Russell Keith-Magee
On Mon, Jun 11, 2012 at 4:26 PM, rico_suave wrote: > Hi All, > > We (as a company) are relatively new to Django and currently implementing a > system where we use inspectdb to use an existing MSSQL 2005 database from > within Django. > We have encountered different problems wi

inspectdb() sees MSSQL varchar([n]) fields as type textfield

2012-06-11 Thread rico_suave
Hi All, We (as a company) are relatively new to Django and currently implementing a system where we use inspectdb to use an existing MSSQL 2005 database from within Django. We have encountered different problems with the ORM part of the application in combination with MSSQL, most of which we

mssql

2012-06-07 Thread Min Hong Tan
hi all, i'm going to use django-mssql. is there any one has use this b4? and any working example? am i need to define a model in models.py?? how if i run syndb. will it sync to my default. mysql database? Regards, MH -- You received this message because you are subscribed to the Google G

Re: Django + Windows Server 2003 + IIS6 + MSSQL 2005

2012-04-29 Thread Samuel Pérez Osés
in32 project ( > http://sourceforge.net/projects/pywin32/). I use that. For SQL Server > connection I use django-mssql (http://code.google.com/p/django-mssql/). > > Jan > > Dne úterý, 17. dubna 2012 16:35:35 UTC+2 Enrique Juan de Dios napsal(a): >> >> Hello Everyone,

Re: Django + Windows Server 2003 + IIS6 + MSSQL 2005

2012-04-26 Thread honyczek
Hi, there is a isapi library in the PyWin32 project (http://sourceforge.net/projects/pywin32/). I use that. For SQL Server connection I use django-mssql (http://code.google.com/p/django-mssql/). Jan Dne úterý, 17. dubna 2012 16:35:35 UTC+2 Enrique Juan de Dios napsal(a): > > Hello Ev

Re: Django + Windows Server 2003 + IIS6 + MSSQL 2005

2012-04-17 Thread George Silva
; wrote: > Is there a real need for using Windows Server, IIS or MSSQL? I have had > really bad experiences with MS stuff in general. > > > On Tue, Apr 17, 2012 at 11:35 AM, Enrique Juan de Dios < > juanded...@gmail.com> wrote: > >> Hello Everyone, >> Please I need

Re: Django + Windows Server 2003 + IIS6 + MSSQL 2005

2012-04-17 Thread Leandro Ostera Villalva
Is there a real need for using Windows Server, IIS or MSSQL? I have had really bad experiences with MS stuff in general. On Tue, Apr 17, 2012 at 11:35 AM, Enrique Juan de Dios wrote: > Hello Everyone, > Please I need tips and common errors to this environment: > Django 1.3 + Windows Se

Django + Windows Server 2003 + IIS6 + MSSQL 2005

2012-04-17 Thread Enrique Juan de Dios
Hello Everyone, Please I need tips and common errors to this environment: Django 1.3 + Windows Server 2003 + IIS6 + MSSQL 2005 I found this project: https://code.djangoproject.com/wiki/DjangoOnWindowsWithIISAndSQLServer Have anyone tested this project? What is the best way to install to setup a

Re: Django is very slow on windows server 2003, mssql database

2012-03-14 Thread Javier Guerra Giraldez
On Wed, Mar 14, 2012 at 8:56 AM, Phanounou wrote: > I got itmany thanks  Javier for your patience and your help.I put > formfield_for_foreignkey method everywhere and now it's super fast. I'm glad > you help me find the solution. Again thanks a lot. You made my day :-) great. i'm glad i wasn

Re: Django is very slow on windows server 2003, mssql database

2012-03-14 Thread Phanounou
I got itmany thanks Javier for your patience and your help.I put formfield_for_foreignkey method everywhere and now it's super fast. I'm glad you help me find the solution. Again thanks a lot. You made my day :-) Regards, VB 2012/3/14 Javier Guerra Giraldez > On Wed, Mar 14, 2012 at 7:55 A

Re: Django is very slow on windows server 2003, mssql database

2012-03-14 Thread Javier Guerra Giraldez
On Wed, Mar 14, 2012 at 7:55 AM, Phanounou wrote: > This is what is taking the most of the time. the gattering of the list of > TObjectAttribute, 3 or 4  times each at a time because TmyObject has 3-4 > attributes value. Because I called it as an admin.StackedInline object in > the admin page. > >

Re: Django is very slow on windows server 2003, mssql database

2012-03-14 Thread Phanounou
Hello Javier, I did the verification to see what is taking so much time to fetch and I realise it is because my model "TmyObject" is related to another class model driving his caracteristics. For example, it's like TmyObject can be any car I have another mod

Re: Django is very slow on windows server 2003, mssql database

2012-03-13 Thread Javier Guerra Giraldez
On Tue, Mar 13, 2012 at 2:14 PM, Phanounou wrote: > Hello, > >  have tryed to use the  formfield_for_foreignkey() and > formfield_for_manytomany() in the admin.py file. In fact, I have reduced > the reponse time (around 10 sec. less then before) by replacing extra = 2 by > extra=0 in my admin.Stac

Re: Django is very slow on windows server 2003, mssql database

2012-03-13 Thread Phanounou
g out closed source products and they will be > eventually merged into core. > > M > From: Virginia > Sent: 13/03/2012 13:58 > To: Django users > Subject: Django is very slow on windows server 2003, mssql database > Good morning everyone, > > I have a web site that was d

RE: Django is very slow on windows server 2003, mssql database

2012-03-13 Thread Martynas RMSMR
Running django on windows is waste of time. In fact, we are phasing out closed source products and they will be eventually merged into core. M From: Virginia Sent: 13/03/2012 13:58 To: Django users Subject: Django is very slow on windows server 2003, mssql database Good morning everyone, I have

Re: Django is very slow on windows server 2003, mssql database

2012-03-13 Thread Javier Guerra Giraldez
On Tue, Mar 13, 2012 at 10:41 AM, Phanounou wrote: > When I look at the traceback from the django_debug_toolbar, there is 1852 > queries in 20956ms, there is several repetition of the same calls. And there > is a lot of unnacessary calls. How can I optimise that? what can I do about > it? is there

Re: Django is very slow on windows server 2003, mssql database

2012-03-13 Thread Phanounou
I'm glad that we might have found the problem and now we are trying to resolve it. The page is "edit" The __unicode__ methode for TrProductsVersion is: def __unicode__(self): return u'%s (version: %s)' %(self.catalogueid, self.prodversionid) Where "catalogueid" (this object has

Re: Django is very slow on windows server 2003, mssql database

2012-03-13 Thread Jani Tiainen
13.3.2012 17:09, Javier Guerra Giraldez kirjoitti: On Tue, Mar 13, 2012 at 9:55 AM, Phanounou wrote: I installed the django_debug_toolbar and I see that in the sql part I have 1852 queries in 18228.00ms. great, so this is indeed the problem. which page is this?, the listing or the edit page?

Re: Django is very slow on windows server 2003, mssql database

2012-03-13 Thread Javier Guerra Giraldez
On Tue, Mar 13, 2012 at 9:55 AM, Phanounou wrote: > I installed the django_debug_toolbar and I see that in the sql part I have > 1852 queries in 18228.00ms. great, so this is indeed the problem. which page is this?, the listing or the edit page? check the SQL code, which tables is it accessing?

Re: Django is very slow on windows server 2003, mssql database

2012-03-13 Thread Phanounou
Good morning Javier, Thanks a lot for the quick answer. The thing is that I'm having the problem on the admin page, it is not involving any coding from my part what so ever. So that is why I don't get it. When you say "the admin objects can be annotated to make the necessary prefetching." what do

Re: Django is very slow on windows server 2003, mssql database

2012-03-13 Thread Tom Evans
On Tue, Mar 13, 2012 at 12:57 PM, Virginia wrote: > Good morning everyone, > > I have a web site that was develop in django on a windows 2003 server > and a mssql database. Latetly it seems that the web site is going > slower and slower. We add datas but not that much to slow it do

Re: Django is very slow on windows server 2003, mssql database

2012-03-13 Thread Javier Guerra Giraldez
On Tue, Mar 13, 2012 at 7:57 AM, Virginia wrote: > We add datas but not that much to slow it down so > much. this is usually not about data itself, being heavy but about having a bad algorithmic behavior. the most common culprit is having unexpected queries inside a loop. for example: {% for ms

Django is very slow on windows server 2003, mssql database

2012-03-13 Thread Virginia
Good morning everyone, I have a web site that was develop in django on a windows 2003 server and a mssql database. Latetly it seems that the web site is going slower and slower. We add datas but not that much to slow it down so much. I run it on my dev environnement with cProfile and looking at

HY010 Function sequence error (mssql django-pyodbc)

2011-09-26 Thread PyMan
query, I don't get the error if using 'SQL Server' as driver (but it's slow since it can't use MARS well, I mean chunked reads). I experience the problem with mssql 2005 and 2008 too. I could understand I get the problem when reading/writing "many" records (not

Django + Legacy MSSQL LATIN1

2011-02-15 Thread Manuel Gonçalves - Analista de Sistemas
Hi guys, I new on the group, it,s my first post: Question 1: I have success to play django + pyodbc on debian linux to connect on MSSQL legacy database, I try django-mssql but it,s look likes play only on windows machines, Does anyone have anothes MSSQL backend to integrate django + MSSQL on

Re: Calling a mssql stored procedure and displaying the result as a datagrid

2010-12-11 Thread Dan Fairs
Hi, > 1. I have a stored procedure in my mssql database server and i would > like to call the procedure in my program with certain parameters.(Is > there a way the results of the stored procedure be represented as a > queryset?) > Read about raw SQL: http://docs.djangopro

Calling a mssql stored procedure and displaying the result as a datagrid

2010-12-10 Thread Pranav
Hi all, I'm new to django and sorry if my questions are too basic. I have a some requirements 1. I have a stored procedure in my mssql database server and i would like to call the procedure in my program with certain parameters.(Is there a way the results of the stored procedure be repres

RE: Connecting to Multiple MSSQL Databases... I've hit an edge case. Help, please!

2010-10-25 Thread Henrik Genssen
just use cursor.close() to close the cursor. is leaking in the sample... Henrik >reply to message: >date: 25.10.2010 13:51:12 >from: "Steven L Smith" >to: "Django users" >subject: Connecting to Multiple MSSQL Databases... I've hit an edge case. >Help

Connecting to Multiple MSSQL Databases... I've hit an edge case. Help, please!

2010-10-25 Thread Steven L Smith
get_photo_from_lenel function fails. >From what I can tell, Django (or django-pyodbc) isn't cleaning up its connection to MSSQL DB #1, and when I use pyodbc to connect to MSSQL DB #2, it seems to be routing it somewhere else. But that's just a guess? I read that the connection persists

django-mssql project... trying to update identity column?

2010-09-14 Thread jamescrowley
Hi guys - I'm not sure if this is the best place to post questions about django-mssql but I couldn't find any mailing list specific to that? Anyway, I'm using django-mssql with the OSQA project (http:// www.osqa.net/) but it's doing an UPDATE statement like this: UPDATE t

Re: error about django and mssql

2010-06-08 Thread Sam Lai
sole - it is missing characters from the start of each line. >> >> 2010/6/8 CCC : >> >> > . >> > I use mssql not mysql >> >> > On 6月8日, 下午3时57分, kanniga sivasubramanian >> > wrote: >> >> hello CCC, >> &g

Re: error about django and mssql

2010-06-08 Thread CCC
ks like it wasn't copied properly from the > console - it is missing characters from the start of each line. > > 2010/6/8 CCC : > > > . > > I use mssql not mysql > > > On 6月8日, 下午3时57分, kanniga sivasubramanian > > wrote: > >>

Re: error about django and mssql

2010-06-08 Thread Sam Lai
If you provide the entire error message, it might help. The excerpt you provided looks like it wasn't copied properly from the console - it is missing characters from the start of each line. 2010/6/8 CCC : > . > I use mssql not mysql > > On 6月8日,

Re: error about django and mssql

2010-06-08 Thread CCC
. I use mssql not mysql On 6月8日, 下午3时57分, kanniga sivasubramanian wrote: > hello CCC, > I think you didn't create the database in the mysql. > First you create the database in mysql. And then you will > change settings.py as a s

Re: error about django and mssql

2010-06-08 Thread kanniga sivasubramanian
wrote: > hi,now I use django-mssql and sqlserver2008, > but I found that it always appear some errors when I do some > command,for example:python manage.py syncdb > the error likes coding error is blow: > raise OperationalError(e, "Error opening connection

error about django and mssql

2010-06-07 Thread CCC
hi,now I use django-mssql and sqlserver2008, but I found that it always appear some errors when I do some command,for example:python manage.py syncdb the error likes coding error is blow: raise OperationalError(e, "Error opening connection: " + connect

Re: error about django and mssql

2010-04-05 Thread Vasil Vangelovski
. On Mon, Apr 5, 2010 at 4:27 AM, CCC wrote: > hi,now I use django-mssql and sqlserver2008, > but I found that it always appear some errors when I do some > command,for example:python manage.py syncdb > the error likes coding error is blow: > raise OperationalError(e, "

error about django and mssql

2010-04-04 Thread CCC
hi,now I use django-mssql and sqlserver2008, but I found that it always appear some errors when I do some command,for example:python manage.py syncdb the error likes coding error is blow: raise OperationalError(e, "Error opening connection: " + connect

error about django and mssql

2010-04-04 Thread CCC
hi,now I use django-mssql and sqlserver2008, but I found that it always appear some errors when I do some command,for example:python manage.py syncdb the error likes coding error is blow: raise OperationalError(e, "Error opening connection: " + connect

error about django and mssql

2010-04-04 Thread CCC
hi,now I use django-mssql and sqlserver2008, but I found that it always appear some errors when I do some command,for example:python manage.py syncdb the error likes coding error is blow: raise OperationalError(e, "Error opening connection: " + connect

django and MSSQL

2009-12-15 Thread miocn
Help: django + mssql the old system to add some content, the database is MSSQL 7.0, I intend to use django 1.1, feasible? Django 1.1 and MSSQL How do I connect?? thanks -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to

Re: Incompatibility with FreeTDS/ODBC and Unicode on a MSSQL server?

2009-04-01 Thread Mark Shewfelt
"Karl Gingerich" wrote: > Mark, I'll up to my eye balls in alligators right now, I'll get back to you > soon. - Karl > > -Original Message- > From: Mark Shewfelt > > Date: Tue, 31 Mar 2009 08:25:55 > To: Django users > Subject: Re: Incompatibi

Re: Incompatibility with FreeTDS/ODBC and Unicode on a MSSQL server?

2009-03-31 Thread Karl Gingerich
Mark, I'll up to my eye balls in alligators right now, I'll get back to you soon. - Karl -Original Message- From: Mark Shewfelt Date: Tue, 31 Mar 2009 08:25:55 To: Django users Subject: Re: Incompatibility with FreeTDS/ODBC and Unicode on a MSSQL server? Hi Karl, I just c

Re: Incompatibility with FreeTDS/ODBC and Unicode on a MSSQL server?

2009-03-31 Thread Mark Shewfelt
Hi Karl, I just came across your post and am having the same issue (Ubuntu 8.04 Server). I managed to build the latest versions of unixODBC and FreeTDS and install them to /usr/local/lib. When I run python and try to import pyodbc I get the following error: administra...@maverick:~/pyodbc-2.1.4$

Re: Incompatibility with FreeTDS/ODBC and Unicode on a MSSQL server?

2009-02-25 Thread kgingeri
Ok, I figured this out myself... I had to un-install all pre-installed odbc stuff - unixODBC (possibly iODBC as well, except it didn't seem to actually uninstall completely) and FreeTDS. I then got source and did configure/make/make installs of unixODBC first, then FreeTDS. This order is importa

Re: Incompatibility with FreeTDS/ODBC and Unicode on a MSSQL server?

2009-02-16 Thread kgingeri
I should add a couple more things here that may have a bearing on my problem... a) I am running Ubuntu Linux and b) I am accessing my data via a VPN connection c) I have done most of my installs via Synaptics but will try to redo some with compiling from source. If I answer my own question, I wi

Incompatibility with FreeTDS/ODBC and Unicode on a MSSQL server?

2009-02-16 Thread kgingeri
I am fairly new to Django and am working my way through the latest tutorial and get the error below. I have the latest dev for Django installed (I know cuz I started out with 0.96), the most recent FreeTDS, pyodbc and django-pyodbc. My isql and running all the api stuff works fine with my SQL Se

MSSQL+django-pyodbc gives ProgrammingError

2008-10-16 Thread Michael J. Korman
I'm using Django 1.0 with django-pyodbc SVN and MS SQL Server. I have a model with a field of type TextField. When I try searching (on a different field) for items of this model in the admin, I get the following error: ProgrammingError at /admin/llreg/propertycontact/ ('42000', '[42000] [FreeT

Re: Django book says MSSQL works with 1.0...?

2008-10-11 Thread bobhaugen
On Oct 10, 5:53 pm, "Adam V." <[EMAIL PROTECTED]> wrote: > > OT: I respect your position but, why you use mssql? > > Our IT systems at work are already Windows / SQL Server based, so it > made sense to do our new web development against the same database. In my c

Re: Django book says MSSQL works with 1.0...?

2008-10-10 Thread Adam V.
> OT: I respect your position but, why you use mssql? Our IT systems at work are already Windows / SQL Server based, so it made sense to do our new web development against the same database. --~--~-~--~~~---~--~~ You received this message because you

Re: Django book says MSSQL works with 1.0...?

2008-10-10 Thread Ovnicraft
2008/10/9 Adam V. <[EMAIL PROTECTED]> > > I'm the django-mssql maintainer; please do post in bugs or weirdness > you run into to http://code.google.com/p/django-mssql/ > and I'll try to get the fixed. OT: I respect your position but, why you use mmsql? > >

Re: Django book says MSSQL works with 1.0...?

2008-10-09 Thread Adam V.
I'm the django-mssql maintainer; please do post in bugs or weirdness you run into to http://code.google.com/p/django-mssql/ and I'll try to get the fixed. Thanks, -Adam V. (For what it's worth, at work we're using Apache + mod_python for our internal development; haven'

Re: Django book says MSSQL works with 1.0...?

2008-10-09 Thread Ulises
> What server did you use? > > If not Apache + mod-python or mod-wsgi, please say more about your > setup? I haven't deployed just yet as I'm still developing. I'm open to suggestions really :) U --~--~-~--~~~---~--~~ You received this message because you are sub

Re: Django book says MSSQL works with 1.0...?

2008-10-09 Thread bobhaugen
On Oct 9, 6:00 am, Ulises <[EMAIL PROTECTED]> wrote: > I'm currently using django-mssql with Django 1.0 no problems at all. Ulises, thanks. What server did you use? If not Apache + mod-python or mod-wsgi, please say more ab

Re: Django book says MSSQL works with 1.0...?

2008-10-09 Thread Malcolm Tredinnick
On Thu, 2008-10-09 at 03:58 -0700, bobhaugen wrote: > ...but Django documentation does not mention it. What is the real > current story? > > http://www.djangobook.com/en/beta/chapter02/ says: > > "As of version 1.0, Django supports five database engines: > [...] > * Microsoft SQL Server (h

Re: Django book says MSSQL works with 1.0...?

2008-10-09 Thread Ulises
> "As of version 1.0, Django supports five database engines: > [...] >* Microsoft SQL Server (http://www.microsoft.com/sql/)" > > I also see these seemingly-active django + MSSQL projects in Google > code: > > http://code.google.com/p/django-mssql/ > h

Django book says MSSQL works with 1.0...?

2008-10-09 Thread bobhaugen
gly-active django + MSSQL projects in Google code: http://code.google.com/p/django-mssql/ http://code.google.com/p/django-pyodbc/ I don't see a backend for MSSQL under django/db/backends. Most recent mention I found in django-users was this about django- pyodbc: http://groups.google.com/gro

weird mssql issue

2008-07-09 Thread Bobby Roberts
hey gang - got a really weird issue trying to connect to any mssql databases from home. I have Charter cable Internet, mssql 2000 running Kaspersky firewall.For some reason I can no longer connect to a mssql databases even when I have my firewall down. The issue was sudden and without

Re: adodbapi with mssql 2000

2007-08-18 Thread Michal PL
MS SQL 2000 and (probably) adodbapi library. When > > django tries to get session information from django_session table it > > asks for records with the where clause: expire_date > %s (in my case > > %s is '2007-08-17 16:27:47.82'). > > Hi Michal, > >

Re: adodbapi with mssql 2000

2007-08-17 Thread Russell Keith-Magee
le it > asks for records with the where clause: expire_date > %s (in my case > %s is '2007-08-17 16:27:47.820000'). Hi Michal, Unfortunately, the MSSQL backends for Django are not in a very good state at the moment. There are a number of problems with this database backend. T

adodbapi with mssql 2000

2007-08-17 Thread Michal PL
I'm new here so let me say hello and sorry for my English to everybody. I got a problem with MS SQL 2000 and (probably) adodbapi library. When django tries to get session information from django_session table it asks for records with the where clause: expire_date > %s (in my case %s is '2007-08-1

Re: Again, django and MSSQL

2007-07-03 Thread Carl Karsten
mamcxyz wrote: > I try, with not sucess to apply the patch for make worj django and MS > Sql. > > > The tickets is a jungle and not see the logic in how is the thing > organized. I'm building a store based in satchmo for integrate a > couple of local ERP system, based in MS Sql, so I have a moti

Again, django and MSSQL

2007-07-03 Thread mamcxyz
I try, with not sucess to apply the patch for make worj django and MS Sql. The tickets is a jungle and not see the logic in how is the thing organized. I'm building a store based in satchmo for integrate a couple of local ERP system, based in MS Sql, so I have a motivation to work on it... Anyb

Re: inspectdb and mssql

2007-06-11 Thread Malcolm Tredinnick
On Mon, 2007-06-11 at 17:21 -0500, Carl Karsten wrote: [...] > What all do I need to do to add a new backend? basically, I want to try > using > pymssql (work on linux) instead of adodbapi (which I am assuming adodbapi > only > works on win?) Add a new directory under django/db/backends/. It

  1   2   >