Hi all, sorry; I know that this is an ever-coming-back question, but I need to dig a bit deeper to get further, before deciding to struggle on or give up.
I've been coding happily with Django for over a year, using an Ubuntu server with a PostgreSQL database and a development environment on 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, but I have managed to get an Ubuntu server to act as a front-end towards the database. I have installed Django on the Ubuntu server and can access the database using Python and pymssql (0.8). But I have not had any luck with the different external efforts to interface Django against MS SQL Server. As far as I have seen from this forum there is two different external development efforts for Django MS SQL support; django-mssql and django- pydobc, and I have tried both with no luck. Here is my report: django-mssql (http://code.google.com/p/django-mssql/) ---------------------------------------------------------------- I seems that django-mssql is a Windows-only solution, since it is based on sqlserver_ado, which in turn is dependent on win32com.client, which is Windows-specific. As I have a good development-server pairing on my Mac laptop and the Ubuntu server, I would rather not switch to development in a Windows environment, so this does not seem to be a viable solution to me. django-pyodbc (http://code.google.com/p/django-pyodbc/) ------------------------------------------------------------------- django-pyodbc seemed to be a much more promising path to walk, since it is based on pyodbc and pymssql, which both seems to be rather platform neutral. The present django-pyodbc is furthermore primarily based on pymssql, which I already have running on both my server and development environment against the MS SQL Server. But when I try to install and run django-pyodbc I run into a number of basic problems. The first problem is that the developer suggests the package to be installed in a directory named django-pyodbc and called in as an external module, but Python doesn't allow for hyphens in module names. I have tried to rename the module to django_pyodbc to get around the problem, but the files of the module have a number of hard-coded includes referring to django-pyodbc, so I had to edit all of those also, but didn't get it working anyhow. My question is: Is there anyone around running Django on a Linux platform towards an MS SQL Server with some kind of Django-integrated database backend support? If, so; how did you do it? I'm not interested in fancy stuff like paging record sets (I've understood that there is a lack of support for this in MS SQL Server), but just basic Django model support. Thanks for any help on this, Ulf --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
