Re: Change sqlite database to sql server

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

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 emai

Re: ms sql server connectivity to django

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

Re: ms sql server connectivity to django

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

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

'USER': 'XXX', 'PASSWORD': 'XXX', 'NAME': 'XXX', #name of your table 'CONN_MAX_AGE': 0, 'AUTOCOMMIT': True, 'OPTIONS': { 'driver': '

Re: ms sql server connectivity to django

27;, 'PASSWORD': 'xxx', 'NAME': 'xx',#table name 'CONN_MAX_AGE': 0, 'AUTOCOMMIT': True, 'OPTIONS': { 'driver': 'ODBC Driver 17 for SQL Server', &#x

Re: Connect Django with SQL Server 2012

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 a

Re: Connect Django with SQL Server 2012

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

how to connect django with SQL Server ?

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

10061 Connection refused - pyodbc - SQL Server 2008 - Win7

Group, I am attempting to connect Django with SQL Server 2008. My dev server is running on a Win 7 box and SQL Server is on a Win 2003 box. When posting from the authentication form, I get exception 10061, 'Connection refused'. Traceback below. I am using django-pyodbc revision 115. I

Problem with text encoding MS SQL Server 2005

Hello, I'm trying to store Django data on MS SQL Server 2005 using: http://code.google.com/p/django-pyodbc/ (pyodbc + FreeTDS) As long as I'm storing string consist of ASCII characters everything is ok. When I'm using unicode (ex. '\xc5\x82'), django t

Microsoft SQL Server and Azure SQL Database support

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

Connect to SQL server but error when migrations

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

Connecting to a MS SQL server from django

I am trying to connect to a MS SQL server from django on Linux using Vernon Cole's django-mssql package (https://bitbucket.org/vernondcole/django-mssql-ado-merge/src). When I first tried to connect it failed with: Exception Type: DatabaseError at /report/CDSEM/EventsTable/ Exception

Porting to Django Linux with SQL Server Backend

The group has been developing locally with sqllite on Windows. We are porting the installation to a Linux environment /windows sql server. Looking for suggestions for database connectors from Linux to sql server 2014 using: python3.3 django 1.7 I have installed a local copy of sql server to

Re: Djnago 1.9.5 with SQL SERVER 2012 connect??

gt; 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' > &

Re: Djnago 1.9.5 with SQL SERVER 2012 connect??

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.Programmi

Who has the better support for Sql Server?

I submit this patch some time ago: http://code.djangoproject.com/ticket/5062 (latter turn to http://code.djangoproject.com/ticket/5246) However, after get invalidad and the decision to support it elsewhere, I wonder which have the better support of the external sql backend to help to improve it?

ANN: New alpha backend for MS Sql Server

If want/need support for mssql, I hope this help. I submit a ticket with patchs for enable a new backend for sql server, so we can have a clean direction from the ado_mssql confusion of tickets, and have a single point for development. Is at http://code.djangoproject.com/ticket/5062. I&#

Is MS SQL Server support coming anytime soon?

We're using Oracle and SQL Server at work--the lack of support for those two is really a killer. What is involved in creating such a support for a DB--any doc/anything to start? Maybe I can take a look at the SQL Server side. Thanks

Connection with SQL server and user registration form

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

Configuration settings for Sql Server database in django

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

Anyone got a backend for MS SQL Server working?

n Max OS X and PostgreSQL on my MacBook to develop databases for bibliometric analyzes. A few months ago, I started working with a new organization that is running a big bibliometric database in a Windows environment on an MS SQL Server. I'm not in the position to suggest a platform switch,

Re: Problem with text encoding MS SQL Server 2005

OK, we managed to solve this ourselves. W dniu 3 lutego 2010 18:08 użytkownik Filip Gruszczyński napisał: > Hello, > > I'm trying to store Django data on MS SQL Server 2005 using: > > http://code.google.com/p/django-pyodbc/ (pyodbc + FreeTDS) > > As long as I'm

Re: Problem with text encoding MS SQL Server 2005

On Feb 3, 2010, at 1:30 PM, Filip Gruszczyński wrote: > OK, we managed to solve this ourselves. > It would be nice if you mentioned what the cause was in detail, and what the fix was. Just in case someone finds your posts many months from now and is trying to solve the same problem. Shawn

Re: Problem with text encoding MS SQL Server 2005

Sure. In file freetds.conf you should set client charset = UTF-8 and it started to work. I heard, that there might be still some problems with, but we haven't yet encountered them. 2010/2/3 Shawn Milochik : > > On Feb 3, 2010, at 1:30 PM, Filip Gruszczyński wrote: > >> OK, we managed to solve t

Re: Microsoft SQL Server and Azure SQL Database support

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

Re: Microsoft SQL Server and Azure SQL Database support

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: Connecting to a MS SQL server from django

The default port for MySQL is 3306. Have you tried that one? -- - Mark *Try this new Instant Django Hosting * -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubsc

Re: Connecting to a MS SQL server from django

On 01/14/2014 03:15 PM, Larry Martell wrote: > I am trying to connect to a MS SQL server from django on Linux using > Vernon Cole's django-mssql package > (https://bitbucket.org/vernondcole/django-mssql-ado-merge/src). > > When I first tried to connect it failed with:

Re: Connecting to a MS SQL server from django

On Tuesday, January 14, 2014, Mark Moss wrote: > The default port for MySQL is 3306. Have you tried that one? > I'm not trying to connect to MySQL - I'm trying to connect to Microsoft SQL server. -- You received this message because you are subscribed to the Google Group

Re: Connecting to a MS SQL server from django

ote: > >> The default port for MySQL is 3306. Have you tried that one? >> > > > I'm not trying to connect to MySQL - I'm trying to connect to Microsoft > SQL server. > > -- > You received this message because you are subscribed to the Google Groups > "

Re: Connecting to a MS SQL server from django

ux? > On Wed, Jan 15, 2014 at 6:46 AM, Larry Martell > wrote: >> >> On Tuesday, January 14, 2014, Mark Moss wrote: >>> >>> The default port for MySQL is 3306. Have you tried that one? >> >> >> >> I'm not trying to connect to MySQL -

Re: Connecting to a MS SQL server from django

Maybe Your MSSQL server is listening only on loopback interface. Telnet from linux box to windows server on port 1433 and check if port is open. You can see also this few pages, just depends on Your server version.: http://blogs.msdn.com/b/sqlblog/archive/2009/07/17/how-to-configure-sql-server-to

Re: Connecting to a MS SQL server from django

pycharm and jetbrains tools come with a db explorer with a simple google search I found this [0] and [1] which have some references, you could also try [2] with wine [0] http://stackoverflow.com/questions/399505/sql-server-gui-for-linux [1] http://stackoverflow.com/questions/721852/developer

Re: Connecting to a MS SQL server from django

On Wed, Jan 15, 2014 at 9:51 AM, Avraham Serour wrote: > pycharm and jetbrains tools come with a db explorer > > with a simple google search I found this [0] and [1] which have some > references, you could also try [2] with wine > > [0] http://stackoverflow.com/questions/399505/

Re: Connecting to a MS SQL server from django

Larry, +1 for Pycharm (JetBrains). I use their DB tools to explore both MS SQL and MySQL DBs. If you like, I can dig up my notes on exactly how I made the connection from PyCharm to MS SQL Server. --Fred Fred Stluka

Re: Connecting to a MS SQL server from django

Larry, We tried django-mssql and gave up. Much better luck with django-pyodbc. We use the avidal version of it, along with pyodbc, FreeTDS, and unixODBC. Works perfectly. If you like, I can dig up my notes on exactly how we made the connection from Django to MS SQL Server. --Fred

Re: Connecting to a MS SQL server from django

d gave up. Much better luck with > django-pyodbc. We use the avidal version of it, along with pyodbc, > FreeTDS, and unixODBC. Works perfectly. If you like, I can dig up > my notes on exactly how we made the connection from Django to > MS SQL Server. > > --Fred > _

Re: Connecting to a MS SQL server from django

s'].append('odbc') # Apple has decided they won't maintain the iODBC system in OS/X and has added deprecation warnings in 10.8. # For now target 10.7 to eliminate the warnings. Do these steps: $ . ~/pythons/hhl/bin/activate $ cd /tmp $ g

Re: Connecting to a MS SQL server from django

- setup.py2013-12-19 21:35:21.0 -0500 > *** > *** 145,151 > > elif sys.platform == 'darwin': > ! # OS/X now ships with iODBC. > ! settings['libraries'].append('iodbc') > >

Re: Connecting to a MS SQL server from django

000 -0500 > ******* > *** 145,151 > > elif sys.platform == 'darwin': > ! # OS/X now ships with iODBC. > ! settings['libraries'].append('iodbc') > > # Apple has decided they

Re: Porting to Django Linux with SQL Server Backend

anfre On Wednesday, October 15, 2014 9:03:54 AM UTC-4, robert brook wrote: > > The group has been developing locally with sqllite on Windows. > > We are porting the installation to a Linux environment /windows sql server. > > Looking for suggestions for database connectors from Linu

Re: Porting to Django Linux with SQL Server Backend

jango-pymssql (https://github.com/aaugustin/django-pymssql). > > Regards, > Michael Manfre > > On Wednesday, October 15, 2014 9:03:54 AM UTC-4, robert brook wrote: >> >> The group has been developing locally with sqllite on Windows. >> >> We are porting the

Re: Porting to Django Linux with SQL Server Backend

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, >> Michael Manfre >> >> On Wednesday, October 15, 2014 9

Re: Porting to Django Linux with SQL Server Backend

connect to sql server from Linux At this point what I am trying to do is use sqlalchemy wherever I can in the views to improve functionality and performance. And I will be using the built in ORM (pyodbc-azure) to log users on to take advantage of the built in functionality of the user model. Any

Re: Porting to Django Linux with SQL Server Backend

Your options are limited if you want to connect to a 2012 SQL Server. The azure driver is the only one that would work for us and we tested everything we could find. K On Thursday, October 16, 2014 7:50:15 AM UTC-7, robert brook wrote: > > Thanks for your response. > > I am in th

Re: Porting to Django Linux with SQL Server Backend

t;>> >>> It's hard to give constructive feedback without knowing 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 (h

Re: Who has the better support for Sql Server?

Hi, http://code.google.com/p/django-mssql/ holds the MSSQL backend as a separate project as was the recommended action by mtredinnick in ticket #5947. Hope this helps. El vie, 09-05-2008 a las 09:33 -0700, mamcxyz escribió: > I submit this patch some time ago: > > http://code.djangoproject.com/t

Re: Is MS SQL Server support coming anytime soon?

On 7/25/06, Ray <[EMAIL PROTECTED]> wrote: > > We're using Oracle and SQL Server at work--the lack of support for > those two is really a killer. > > What is involved in creating such a support for a DB--any doc/anything > to start? Maybe I can take a look at th

Re: Is MS SQL Server support coming anytime soon?

I know little about this, but oracle is found in the django db backends. It uses cx_Oracle, which I also know nothing about. http://code.djangoproject.com/browser/django/trunk/django/db/backends/oracle --~--~-~--~~~---~--~~ You received this message because you a

Re: Is MS SQL Server support coming anytime soon?

I've been floating around looking for SQL Server support too. I'm starting on Django for our website. I can use MySQL/Postgres for the web side of things (and prefer too), but when it comes to linking to our backend customer data I have to use SQL Server - I suspect a lot of people will

Re: Is MS SQL Server support coming anytime soon?

There's a thread I started in the python newsgroup about pymssql but where were also discussed several other ways to connect to a MSSqlServer database. I think it contains usefull info on the subject [1] Some days ago someone also pointed out to me Pyodb [2], which might be a good option (althoug

Re: Is MS SQL Server support coming anytime soon?

We use a scheduled migration from SQL Server to Postgres with a third party app: http://www.sqledit.com/mk/index.html It has to be run on a windows box, but it allows you to do cool things like create a table in the postgres database with the results of a SQL query on the SQL Server database

Re: Is MS SQL Server support coming anytime soon?

On 7/27/06, Filipe <[EMAIL PROTECTED]> wrote: > > There's a thread I started in the python newsgroup about pymssql but > where were also discussed several other ways to connect to a > MSSqlServer database. I think it contains usefull info on the subject > [1] Yeah, that was outstanding. It leave

Re: Connection with SQL server and user registration form

lli > 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 are models that are using SQLite, is it > mandator

Re: Connection with SQL server and user registration form

li > 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 are models that are using SQLite, is > it mandator

Re: Configuration settings for Sql Server database in django

n Wed, Oct 10, 2018 at 11:50 AM Rakhee Menon wrote: > 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 > > -

Re: Configuration settings for Sql Server database in django

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

Need Guidance to setup Django with MS SQL server

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': {

Unable to establish odbc connection to MS SQL Server

USER': 'user', 'PASSWORD': 'password', 'OPTIONS': {'ODBC Driver 17 for SQL Server', } } } And here is the error: (venv) C:\Users\Kirk\PycharmProjects\PyShop>manage.py runserver Unhandle

Re: Anyone got a backend for MS SQL Server working?

Ulf I haven't played with this second solution, but I did just check out a copy of the django-pyodbc project. You should be OK following the author's instructions. He said to add the django-pydobc directory (where ever you choose to put it) to your PYTHONPATH. The name of the module(s) that get

Re: Anyone got a backend for MS SQL Server working?

[Posted this reply yesterday, but I can't see it, I post it again. Sorry for any duplication. / Ulf ] On Jun 27, 4:12 pm, gordyt <[EMAIL PROTECTED]> wrote: > Ulf I haven't played with this second solution, but I did just check > out a copy of the django-pyodbc project.  You should be OK following

Re: Anyone got a backend for MS SQL Server working?

Hi again all, after a few days of struggling with django-pyodbc, I have finally got past the "ImportError: No module named django-pyodbc.db.mssql.base" stage. The problem was that the module package was missing __init__.py files in the directories above the mssql directory. So I added two empty _

Re: Anyone got a backend for MS SQL Server working?

On Wed, 2008-07-02 at 23:18 -0700, Ulf Kronman wrote: > Hi again all, > after a few days of struggling with django-pyodbc, I have finally got > past the "ImportError: No module named django-pyodbc.db.mssql.base" > stage. > > The problem was that the module package was missing __init__.py files >

Re: Anyone got a backend for MS SQL Server working?

> patching Django (which would be a shame). I don't know, but there do > appear to be some problems that need to be sorted out Yes, you are right. When I searched for MS SQL server support, I came across this Django ticket: http://code.djangoproject.com/ticket/5062 As you can see, a num

Using syncdb and sql server does not create dbo tables

I am creating tables in sql server for the first time. I usually use mysql. The tables are created with a domain prefix rather than dbo.table (domain\myname.table instead of dbo.table) How do I get django to creatte the tables the way I want them to be created -- You received this message

connecting to MS SQL server in addition to default MySQL

I have a django app that connects to a MySQL server in the usual way. I've noe been asked to add some new functionality that requires that I pull data from a MS SQL server database running on a Windows box. I don't want to use the django ORM with the db, just access it directly with some

How mature is Microsoft SQL Server support by the ORM?

Hello, There is an upcoming project where support for an existing application where Microsoft SQL Server is being used. Switching to another database is not an option. There are hundreds of custom reports that the users have created with Crystal Reports. I found django-sqlserver <ht

Re: Need Guidance to setup Django with MS SQL server

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_se

Re: Need Guidance to setup Django with MS SQL server

pport 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

#x27;: 'user', 'PASSWORD': 'password', 'HOST': 'DbHost', 'OPTIONS': { 'driver': 'ODBC Driver 13 for SQL Server', 'unicode_results': True, },

Re: Unable to establish odbc connection to MS SQL Server

x27;NAME': 'MyDbName', 'USER': 'user', 'PASSWORD': 'password', 'HOST': 'DbHost', 'OPTIONS': { 'driver': 'ODBC Driver 13 for SQL Server', &

Establish a connection between django and SQL Server using pyodbc

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 serve

Re: Facing Issue with ODBC Driver 17 for SQL Server

RC 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: connecting to MS SQL server in addition to default MySQL

/en/dev/topics/db/sql/#executing-custom-sql-directly On Wed, Aug 7, 2013 at 2:42 PM, Larry Martell wrote: > I have a django app that connects to a MySQL server in the usual way. > I've noe been asked to add some new functionality that requires that I > pull data from a MS SQL s

Re: connecting to MS SQL server in addition to default MySQL

way. > I've noe been asked to add some new functionality that requires that I > pull data from a MS SQL server database running on a Windows box. I > don't want to use the django ORM with the db, just access it directly > with some sql in my python code. What's the

Re: connecting to MS SQL server in addition to default MySQL

I just have read-only access to the MS SQL server database. I can't install anything on the Windows box. So all I can do is execute sql queries against it. On Thu, Aug 8, 2013 at 9:19 AM, Michael Manfre wrote: > Any particular reason you want to completely avoid the ORM? My main projec

Re: connecting to MS SQL server in addition to default MySQL

e of badly configured charsets on the server and existing data, so i couldn't get unicode text. in the end, i settled for just using py-odbc to access the MS-SQL Server tables (in latin1, ugh) and the ORM for the 'main' MySQL data. so, if you're lucky, you should just be able

Re: connecting to MS SQL server in addition to default MySQL

#x27;t get > unicode text. in the end, i settled for just using py-odbc to access > the MS-SQL Server tables (in latin1, ugh) and the ORM for the 'main' > MySQL data. > > so, if you're lucky, you should just be able to set an ORM access to > both servers. if not, t

Re: connecting to MS SQL server in addition to default MySQL

On Fri, Aug 9, 2013 at 8:53 AM, Larry Martell wrote: > On Friday, August 9, 2013, Javier Guerra Giraldez wrote: >> >> On Thu, Aug 8, 2013 at 9:22 PM, Larry Martell >> wrote: >> > So all I can do is execute sql >> > queries against it. >> >> >> good news: that's all the ORM needs. :-) > > > Don't

Re: connecting to MS SQL server in addition to default MySQL

On Friday, August 9, 2013, Javier Guerra Giraldez wrote: > On Fri, Aug 9, 2013 at 8:53 AM, Larry Martell > > > wrote: > > On Friday, August 9, 2013, Javier Guerra Giraldez wrote: > >> > >> On Thu, Aug 8, 2013 at 9:22 PM, Larry Martell > >> > > > >> wrote: > >> > So all I can do is execute sql >

Re: connecting to MS SQL server in addition to default MySQL

rote: >> >> I have a django app that connects to a MySQL server in the usual way. >> I've noe been asked to add some new functionality that requires that I >> pull data from a MS SQL server database running on a Windows box. I >> don't want to use the django OR

Re: How mature is Microsoft SQL Server support by the ORM?

On Thu, Nov 21, 2013 at 1:20 PM, CLIFFORD ILKAY wrote: > Hello, > > There is an upcoming project where support for an existing application > where Microsoft SQL Server is being used. Switching to another database > is not an option. There are hundreds of custom reports that t

Re: How mature is Microsoft SQL Server support by the ORM?

Clifford, I use: - http://code.google.com/p/django-pyodbc/ No problem except that the MS SQL Server DB identifies itself as using UTF-8, but actually contains Windows-1252 chars, so we get UnicoeDecodeError a lot and have to repair the data. --Fred

Re: How mature is Microsoft SQL Server support by the ORM?

an existing application > where Microsoft SQL Server is being used. Switching to another database > is not an option. There are hundreds of custom reports that the users > have created with Crystal Reports. I found django-sqlserver > <https://pypi.python.org/pypi/django-sqlserver&l

Re: How mature is Microsoft SQL Server support by the ORM?

On 11/21/2013 11:41 PM, Fred Stluka wrote: > Clifford, > > I use: > - http://code.google.com/p/django-pyodbc/ > > No problem except that the MS SQL Server DB identifies itself > as using UTF-8, but actually contains Windows-1252 chars, so > we get UnicoeDecodeError a lo

Re: How mature is Microsoft SQL Server support by the ORM?

On 11/22/2013 05:47 AM, Anssi Kääriäinen wrote: > Check out https://bitbucket.org/Manfre/django-mssql/overview - my > understanding is that it is well maintained and supports also 2012. Thank you Anssi. -- Regards, Clifford Ilkay 647-778-8696 Dinamis -- You received th

Re: How mature is Microsoft SQL Server support by the ORM?

11/21/2013 11:41 PM, Fred Stluka wrote: Clifford, I use: - http://code.google.com/p/django-pyodbc/ No problem except that the MS SQL Server DB identifies itself as using UTF-8, but actually contains Windows-1252 chars, so we get UnicoeDecodeError a lot and have to repair the data. Hi Fred, Is

About to defect, need MS SQL Server patch for 0.96pre or 0.95

Our Django app - currently running against version 0.96pre - has a business requirement to support Microsoft SQL Server or Oracle. We're on the verge of defecting to Ruby-on-Rails, with it's out of the box MS-SQL support, as the only SQL Server patch that we have found only works ag

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

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

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

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: About to defect, need MS SQL Server patch for 0.96pre or 0.95

On 3/1/07, Fuzzkat <[EMAIL PROTECTED]> wrote: > > Our Django app - currently running against version 0.96pre - has a > business requirement to support Microsoft SQL Server or Oracle. There is a branch for Oracle support. After some discussion at PyCon, it seems there is a plan

Re: About to defect, need MS SQL Server patch for 0.96pre or 0.95

wrote: > > > On 3/1/07, Fuzzkat <[EMAIL PROTECTED]> wrote: > > > > Our Django app - currently running against version 0.96pre - has a > > business requirement to support Microsoft SQL Server or Oracle. > > There is a branch for Oracle support. After some discus

Re: About to defect, need MS SQL Server patch for 0.96pre or 0.95

>On 3/1/07, Jeremy Dunck <[EMAIL PROTECTED]> wrote: >> >> >> On 3/1/07, Fuzzkat <[EMAIL PROTECTED]> wrote: >> > >> > Our Django app - currently running against version 0.96pre - has a >> > business requirement to support Microsof

Re: About to defect, need MS SQL Server patch for 0.96pre or 0.95

Mike, Sorry for the confusion. The generic paginated views will not work correctly because SQL Server 2000 doesn't naively support the limit offset functionality that other DBs do. I think that SQL Server 2005 does have that functionality, but so many people still use SQL Server 2000 t

Re: About to defect, need MS SQL Server patch for 0.96pre or 0.95

Wow, slightly stunned that SQL Server 2000 doesn't have that, at least Oracle has ROWNUM...! Thanks for the clarification though :) Mike On 3/1/2007, "Sean De La Torre" <[EMAIL PROTECTED]> wrote: >Mike, > >Sorry for the confusion. The generic paginated views wi

Re: About to defect, need MS SQL Server patch for 0.96pre or 0.95

Yeah, it's quite a pain. Most solutions for 2k involve a custom stored procedure to provide the functionality. SQL Server 2005 introduces the ROW_NUMBER keyword to deal with the issue. On 3/1/07, Mike H <[EMAIL PROTECTED]> wrote: > > > > Wow, slightly stunned that SQL S

Re: About to defect, need MS SQL Server patch for 0.96pre or 0.95

I don't think is a soo big issue. If the backend is Sql 2005, you got it. If not, demand that the developer create a store procedure (document the name and params) and you got it. Take in account that the mayority of the times the django model drive the DB. And if not, anyway stored procedur

<    1   2   3   >