looking for a good python module for MS SQL server

Jarek Zgoda jzgoda at o2.usun.pl
Wed Nov 2 06:05:35 EST 2005


Peter Decker napisał(a):

>>Things didn't change, as last update to adodbapi was long time ago... I
>>had no problems with stored procedures accessed using cursor's execute()
>>method (i.e. execute('exec sp_someproc, param')), but I never tried to
>>get any results, just call sp and commit or rollback.
> 
> Can the adodbapi module be used on a Linux/Mac client? If not, what's
> the best choice for cross-platform connectivity to a Microsoft SQL
> Server?

Nope, adodbapi relies on COM/ActiveX subsystem, so it's not available
outside Windows.

PyMSSQL can use DB-LIB or FreeTDS, so it may have use also on
non-windows systems, see http://pymssql.sourceforge.net/ (didn't try
this one, though).

-- 
Jarek Zgoda
http://jpa.berlios.de/



More information about the Python-list mailing list