[Zope] Zope and Windows DB's = NOT! ?

2000-11-14 Thread Mark Pratt

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! ?

2000-11-14 Thread Rik Hoekstra



 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! ?

2000-11-14 Thread Mark Pratt

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! ?

2000-11-14 Thread Pavel V. Piankov

 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! ?

2000-11-14 Thread tom smith

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! ?

2000-11-14 Thread Farrell, Troy

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! ?

2000-11-14 Thread Andy McKay

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! ?

2000-11-14 Thread Mark Pratt

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! ?

2000-11-14 Thread Rik Hoekstra


 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! ?

2000-11-14 Thread Dieter Maurer

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 )