[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) [EMAIL PROTECTED] beehive elektronische medien GmbH http://www.beehive.de phone: +49 30 847-82 0 fax: +49 30 847-82 299 ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [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? 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 ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Zope and Windows DB's = NOT! ?
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) [EMAIL PROTECTED] beehive elektronische medien GmbH http://www.beehive.de phone: +49 30 847-82 0 fax: +49 30 847-82 299 ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Zope and Windows DB's = NOT! ?
> 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 ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Zope and Windows DB's = NOT! ?
on 14/11/00 12:51 pm, Pavel V. Piankov at [EMAIL PROTECTED] 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 ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] Zope and Windows DB's = NOT! ?
I've been using ZODBCDA 3.1.0b3 for 3 months on MS Acccess with no problems. Zope 2.2.2 Access 97 SR2 NT 4 SP6a 100MHz P5 32MB Ram Troy ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Zope and Windows DB's = NOT! ?
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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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) [EMAIL PROTECTED] > beehive elektronische medien GmbH http://www.beehive.de > phone: +49 30 847-82 0 fax: +49 30 847-82 299 > > > ___ > Zope maillist - [EMAIL PROTECTED] > 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 ) > ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Zope and Windows DB's = NOT! ?
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) [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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) [EMAIL PROTECTED] > > beehive elektronische medien GmbH http://www.beehive.de > > phone: +49 30 847-82 0 fax: +49 30 847-82 299 > > > > > > ___ > > Zope maillist - [EMAIL PROTECTED] > > 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 ) > > > ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Zope and Windows DB's = NOT! ?
> 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 ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Zope and Windows DB's = NOT! ?
Mark Pratt writes: > 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? I use Zope 2.1.6 and ZODBCDA to access an Access database. I had only the usual Zope 2.1.6 Shared.DC.ZRDB.DA problems. Dieter ___ Zope maillist - [EMAIL PROTECTED] 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 )