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

[Sean M. H. <str...@ma...>]

Thanks to Ian and Joseph--particularly for Joseph's detailed efforts in this
area. I'll take a look, and may have to consider using mxODBC if necessary.
In the near-term the path of least resistance looks most appropriate, but if
I do learn anything I'll happily share. Sometimes you have to hold hands
with the devil. ;)

Sean

> Message: 13
> To: sql...@li...
> From: Joseph Kocherhans <jko...@ma...>
> Date: Tue, 2 Nov 2004 14:59:44 -0700
> Subject: [SQLObject] Re: DBConnection for MS SQL Server / MSDE
> 
> 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
> 
> 
> 
> 
> 
> --__--__--
> 
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
> 
> 
> End of sqlobject-discuss Digest