Le Wed, 04 Feb 2009 20:19:52 +0100, wtr_web a écrit:
> Hello!
> I need to access a SQLServer 2005 by creating, reading and writing by
> a single thread/single user.
> Has anybody experience with some openSrc SW? There are quite large
> amounts of data involved (around a million
> rows in some tables).
> I have only used Oracle-access myself.
Hello,
AFAIK SQLServer speaks the same "TDS" protocol as Sybase (which it
originated from long ago).
So you could try FreeTDS which is a C-level lib to speak this protocol:
http://www.freetds.org/
and especially
http://www.freetds.org/userguide/python.htm
with a corresponding Python binding of this library:
http://python-sybase.sourceforge.net/
(replaces the old
http://object-craft.com.au/projects/sybase/index.html )
(maybe there are other bindings, didn't look further)
FreeTDS is explicitly reporting to work with MS SQL Server, including
recent versions. And it seems much more mature and stable than pymssql...
--
Hope this helps,
Fabien.
_______________________________________________
DB-SIG maillist - DB-SIG@python.org
http://mail.python.org/mailman/listinfo/db-sig
