[ZODB-Dev] RelStorage support to Microsoft SQLServer

[Laurence Rowe]

On 17 November 2010 17:05, Laurence Rowe <l at lrowe.co.uk> wrote:
> On 17 November 2010 16:34, Alan Runyan <runyaga at gmail.com> wrote:
>>> I have read that there is a problem to implement MS-SQL adapter for
>>> Relstorage because the “Two phase commit” feature is not exposed by
>>> MS-SQL server .
>>
>> unsure about that. probably depends on the client access library.
>
> At least when I looked at pyodbc/FreeTDS in 2008 FreeTDS did not have
> support for the tds packets necessary for joining an XA transaction.
> (FreeTDS is the odbc -> SQL Server driver used on unix.) See:
> http://article.gmane.org/gmane.comp.db.tds.freetds/9598. I did have
> some more information on a SQLAlchemy wiki page but that seems to have
> gone now.

Found that here: http://www.sqlalchemy.org/trac/wiki/MSSQLTwoPhaseCommit

Laurence