[SQLObject] Re: DBConnection for MS SQL Server / MSDE

[Joseph K. <jko...@ma...>]

On 2004-11-01 14:05:17 -0700, Ian Bicking <ia...@co...> said:

> Sean M. Hester wrote:
>> I checked the archives for "SQL Server" and "SQLServer" but didn't find
>> anything--my apologies if I'm needlessly rehashing an old topic.
>> Anyway...has anyone already worked on providing DBConnection compatibility
>> with MS's SQL Server 2K or MSDE? If so, would you care to share? If not, are
>> other parties interested if I wind up going down the rabbit hole?
> 
> There's some code in 
> svn://colorstudy.com/home/jkocherhans/SQLObject-mssql-branch , I 
> haven't looked at it at all, so I don't know more.

That branch uses mxODBC, so it *does* require some non-free software. I 
was never able to find another stable way to connect to SQL Server from 
python. I did all of the testing with iODBC and FreeTDS on OS X and 
Linux. It's a point where all but 3 tests pass. (and those are cursor 
splitting tests IIRC) Eventually I ran into threading/pooling issues 
with a zope3 DA I wrote on top of it, but for simple stuff it was 
working fine. I never did track down where the threading issues came 
into play though. I pretty much gave up and moved over to postgres + 
some scripts to replicate the sql server data nightly. Feel free to 
check it out and ask questions.

Joseph