MSSQL, and "Incorrect syntax near 'DEFERRABLE'"

[avera...@gmail.com]

I'm working on getting the ado_mssql engine working on my fresh
install of apache and django on Windows. When I tried and sync the db
with the auth app, or even the tutorial poll app, i get an error that
can be seen here:

http://dpaste.com/hold/10603/

I patched my django to http://code.djangoproject.com/attachment/ticket/2358/mssql_update8a.diff
as well

Any ideas?

[Jeremy Dunck]

On 5/18/07, avera...@gmail.com <avera...@gmail.com> wrote:
...
> Any ideas?

SQL Server is not really supported. Support is desired by many, but
no one has committed to establishing and maintaining support.

Example threads:
http://groups.google.com/group/django-developers/search?q=sql+server&start=0&scoring=d&

Most recent discussion (AFAIK):
http://groups.google.com/group/django-developers/browse_frm/thread/68cceeea79921b07/acbb238cacb5158b?lnk=gst&q=sql+server&rnum=1#acbb238cacb5158b

Sorry for the bad news. :(

[avera...@gmail.com]

Sad... I'm wondering if anyone has it working in a somewhat stable
state- I'm running SQL 2005 if that helps at all...

On May 18, 12:21 pm, "Jeremy Dunck" <jdu...@gmail.com> wrote:

> On 5/18/07, average...@gmail.com <average...@gmail.com> wrote:
> ...
>
> > Any ideas?
>
> SQL Server is not really supported. Support is desired by many, but
> no one has committed to establishing and maintaining support.
>

> Example threads:http://groups.google.com/group/django-developers/search?q=sql+server&...
>
> Most recent discussion (AFAIK):http://groups.google.com/group/django-developers/browse_frm/thread/68...

[Jeremy Dunck]

On 5/18/07, avera...@gmail.com <avera...@gmail.com> wrote:
>

> Sad... I'm wondering if anyone has it working in a somewhat stable
> state- I'm running SQL 2005 if that helps at all...

Those threads have reports of various levels of success.

And yes, running 2005 does help since one of the nagging issues with
support is the lack of limit/offset support in SQL Server; this was
added in 2005.