Re: Django and MS SQL

2006-01-23 Thread Rich Bakos
Cheng Zhang wrote: Hi Cheng, > Actually my previous statement isn't correct, I just realized that > pymssql also claimed to work on Windows, except it will use M$'s > native libraries instead of FreeTDS. You worked this out quicker than I ever could have. Thanks.

Re: Django and MS SQL

2006-01-12 Thread Rich Bakos
Jeroen Ruigrok van der Werven wrote: Hi Jeroen, > Can a bunch of us get together to get a/the pymssql driver fully > operational and Django running as it should? The pymssql driver only supports DB-LIB, which is way outdated and you wont have access to functionality added to MSSQL after versio

Re: Django and MS SQL

2006-01-10 Thread Rich Bakos
Jeremy Dunck wrote: Hi Jeremy, > Yeah, adodbapi was doing something weird with the executeHelper, so we did > this: Yeah I worked that out but haven't gotten too far. I had to make a modification to function_get_sql_clause to support the MS TOP keyword. Also had to modify method_save to provi

Re: Django and MS SQL

2006-01-10 Thread Rich Bakos
Jeremy Dunck wrote: Hi Jeremy, > > The syntax that MS SQL expects: > > select foo from bar where foo = @fooName > > Are we talking about literals or parameters? I'm talking about parameters. > That is, are you expecting: > > select colname from tablename where colname = 'somevalue' > or > sel

Re: Django and MS SQL

2006-01-10 Thread Rich Bakos
Adrian Holovaty wrote: Hi Adrian, > Could you paste the entire traceback you get? Also, would any other MS > SQL users in the audience be able to help? Here is an entire traceback I get when attempting to access the /admin site: Traceback (most recent call last): File "C:\Python24\lib\site

Re: Django and MS SQL

2006-01-10 Thread Rich Bakos
Hi Russ, Thanks for th tip on where to splunk for the offending code. The SQL that is arriving at the sever is in the folowing format: select foo from bar where foo = %sfooName The query parser dies at %s with an invalid syntax exception... The syntax that MS SQL expects: select foo from bar w

Django and MS SQL

2006-01-09 Thread Rich Bakos
? I'm a bit of a Python newbie so I'm pretty unfamiliar with the code base. Django becomes somewhat unusable to me if I can't use it in conjunction with MS SQL. Thanks, Rich Bakos