On 2009-02-05 18:42, Fabien COUTANT wrote: > 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...
FreeTDS does work with MS SQL Server, but it has problems with Unicode and is not (yet) reliable enough to use in production. mxODBC works with FreeTDS on Linux and most other Unix platforms, but due to the above issues we have chosen to develop a new product called "mxODBC Connect" which allows you to use the client driver on the server side, rather than on the client side. For MS SQL Server you can then rely on use the very stable and performant SQL Server Native Client to interface directly to the SQL Server kernel via shared memory. -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Feb 05 2009) >>> Python/Zope Consulting and Support ... http://www.egenix.com/ >>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ >>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/ ________________________________________________________________________ ::: Try our new mxODBC.Connect Python Database Interface for free ! :::: eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48 D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg Registered at Amtsgericht Duesseldorf: HRB 46611 http://www.egenix.com/company/contact/ _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
