[DB-SIG] SQLServer 2005

M.-A. Lemburg mal at egenix.com
Thu Feb 5 21:50:46 CET 2009

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

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

More information about the DB-SIG mailing list