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
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?
In general, the ODBC adapter may be old, but it works well and generally without problems in my experience. In the Zope Book it's even claimed that it's commercially supported! The point is just that it's single threaded. 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. Rik
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
is anybody successfully using a Windows DB such as MS SQL server 7 with Zope? i`ve been using it with MS SQL6.5 > 1,5 year, no problem...
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? Hmm... are you talking about ZODBCDA 3.0.3 or ZmxODBCDA 0.0.1 ? I`ve had some problems with ZmxODBCDA but it is only 0.0.1, younger versions of ZODBCDA were error prone, 3.0.3 is very good.
regards. -- Pavel Cosmos-Mebel, JSC. http://cosmos-mebel.spb.ru
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
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 )
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 )
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.
there used to be a similar issue in a previous version, that had to do with single threads and transactions not being committed. But that was patched long ago. That's probably not it and I know it's kind of cryptic, just thought I'd bring it up, just in case.
guess the only major thing left is the single thread issue.
yes, that's bad. Rik
participants (5)
-
Andy McKay -
Mark Pratt -
Pavel V. Piankov -
Rik Hoekstra -
tom smith