[Zope] RE: [Zope-dev] SQL Server ..?

[Bryan Baszczewski]

ZODBC is a level 2 (at most, if not a level-1 still) Database adapter...
http://www.zope.org/Members/petrilli/DARoadmap
...this supports a global lock on all transactions which will block incoming
requests.

ZmxODBC DA is a Level-3 (multithreaded support)
http://www.zope.org/Members/djay/ZmxODBC/ZmxODBC_0_0_2.tgz/README


Which one is better depends upon your need for the adapter.  ZmxODBC costs
$30.00 while ZODB is free.  ZmxODBC solved the "hang-time" issues we had
with SQL Server queries on our website(s).

-----Original Message-----
From: Anderson Ami [mailto:anderson@websolucoes.com.br]
Sent: Thursday, March 15, 2001 8:10 PM
To: bryanbz@2s2i.com; zope-dev@zope.org; zope@zope.org
Subject: RE: [Zope-dev] SQL Server ..?


What is the diference between ZODBC and ZmxODBC ? Which one is better?

-----Original Message-----
From: zope-dev-admin@zope.org [mailto:zope-dev-admin@zope.org]On Behalf
Of Bryan Baszczewski
Sent: quinta-feira, 15 de março de 2001 18:27
To: zope-dev@zope.org
Subject: [Zope-dev] SQL Server ..?



I am curious of how popular SQL Server is among Zope developers.  We have
recenly upgraded from SQL 7 to 2000 and noticed most of the database support
for Zope centers around Oracle, MySQL, Postgres, Sybase, etc...

How many people are using this ZmxODBC database adapter?  And what kind of
problems/issues/praise do you have?

Any info would be appreciated.

Bryan Baszczewski
Software Engineer/Technology Strategist
2s2i, Inc.
www.2s2i.com
phone: (703)534-9800 x-203
fax: (703)995-4866
"Because word of mouth has gone global, there's e-Intelligence from 2s2i."




_______________________________________________
Zope-Dev maillist  -  Zope-Dev@zope.org
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists -
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )