[DB-SIG] [summary] Connecting to MS SQL from Python

Anthony Baxter Anthony Baxter <anthony@interlink.com.au>
Thu, 18 Nov 1999 09:32:25 +1100


>>> Hrvoje Niksic wrote
> Eight weeks ago, I asked about the possibilities of connecting to MS
> SQL server from within Python.  I received several responses, and I
> promised to post a summary of my experiences.

> * Wrap Sybase's CTlib into Python.  Peter Godman's Sybase module is
>   supposed to do that, but it appears unmaintained and in a really bad
>   shape.  Besides, it's compliant with the old version of the DB API.
> 
>   For someone knowledgable with databases or with Python internals, it
>   would probably be easy to write his own wrapper, or pick up where
>   Peter left off.  But I am new to the world of databases, and know
>   next to nothing about Python C internals, and for me it's a daunting
>   task.

Brian Hooper's existing ZSybaseDA works for us under Zope1 without too
many troubles. That's for talking from a Redhat Linux 5.2 box with Sybase
ASE 11.0 to an NT4sp5 box with SQL Server 6.5sp3

There's also the soon-to-be-released new ZSybaseDA, which a little bird
tells me will also work when run against SQL Server.

I think Paul said last Friday it would be released "within a week", but
hey, those sales-types always over-promise :) 

Anthony

-- 
Anthony Baxter     <anthony@interlink.com.au>   
It's never too late to have a happy childhood.