hi rik, On Tue, 14 Nov 2000, Rik Hoekstra wrote:

In general, the ODBC adapter may be old, but it works well and generally without problems in my experience.

wow. we've had exactly the opposite experience and judging by my informal discussions with other Zope users at the Systems 2000 convention in Munich -- so have others.

In the Zope Book it's even claimed that it's commercially supported!

guess i should take a look at that book again.

The point is just that it's single threaded.

like i said ancient ....

If you need to use SQL Server 7 there also is a mxODBC adapter, that claimed to be multithreaded. I don't know about its status right now.

this was an option we discussed at systems. this adaptor seems to be continually improved and well supported. regards, mark -------------------------------------------------------------- mark pratt (managing director) mark@beehive.de beehive elektronische medien GmbH http://www.beehive.de phone: +49 30 847-82 0 fax: +49 30 847-82 299

on 14/11/00 12:51 pm, Pavel V. Piankov at pashah@cosmos-mebel.spb.ru wrote:

...

it seems that the ODBC adaptor is ancient and very error prone .... so can i conclude that Zope and DB integration under windows is not an option? I found the oDBC stuff works fine with Access and SQLServer. Though passing variables to the sqlMethod is little bit of a black art

good luck tom

hello andy, hello all others who answered my post, first of all thank you for letting me know the positive experiences you have had with the ODBC adaptor and your various installations. i'm relieved that Zope and window's DB's do work together -- and this prompted some new tests on my part. their still seems to be a minor issue with an error message the first time we query a MS SQL 6.5 DB. a few reloads later everything seems to work fine. kind of weird. guess the only major thing left is the single thread issue. thanks again, mark -------------------------------------------------------------- mark pratt (managing director) mark@beehive.de beehive elektronische medien GmbH http://www.beehive.de phone: +49 30 847-82 0 fax: +49 30 847-82 299 On Tue, 14 Nov 2000, Andy McKay wrote:

I have used Zope 2.1.6, 2.2.0, 2.2.1, 2.2.2 with MS Access 2000, MS SQL 7 and MS SQL 2000 Beta and Full.

The only problem was with 2.2.0 where permissions broke the ZODBC driver was broken, there was a patch and 2.2.1 up had the problem fixed.

What version of Zope, OS, ZODBC and DB are you using and what is the problem?

-- Andy McKay, Developer. ActiveState.

----- Original Message ----- From: "Mark Pratt" <mpratt@beehive.de> To: <zope@zope.org> Sent: Tuesday, November 14, 2000 3:30 AM Subject: [Zope] Zope and Windows DB's = NOT! ?

...

hi,

is anybody successfully using a Windows DB such as MS SQL server 7 with Zope?

it seems that the ODBC adaptor is ancient and very error prone .... so can i conclude that Zope and DB integration under windows is not an option?

regards,

mark

-------------------------------------------------------------- mark pratt (managing director) mark@beehive.de beehive elektronische medien GmbH http://www.beehive.de phone: +49 30 847-82 0 fax: +49 30 847-82 299

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