If I'm going to be able to use Linux and Zope as my intranet site and crack the Microsoft stronghold, I need to access my MsAccess databases from Zope in Linux. Is this possible? I'm struggling with mxODBC in conjunction with iODBC. not having much luck. Are there any zopish alternatives. -mjm
While I've read on this mailing list that there are some Linux ODBC drivers, I have no experience with them. What I do is run a Zope installation on one of the Windows machines, which can access the MSAccess DB with the Windows ODBC. Then the Linux Zope gets the data from the Windows Zope using some form of RPC, such as Client.py (http://www.zope.org/Members/lstaffor/ZClientMethod) or XML-RPC (which I have not tried). -- Loren
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Montagne, Michael Sent: Thursday, June 28, 2001 17:05 To: 'zope@zope.org' Subject: [Zope] MSAccess
If I'm going to be able to use Linux and Zope as my intranet site and crack the Microsoft stronghold, I need to access my MsAccess databases from Zope in Linux. Is this possible? I'm struggling with mxODBC in conjunction with iODBC. not having much luck. Are there any zopish alternatives.
-mjm
_______________________________________________ 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 )
Loren Stafford wrote:
While I've read on this mailing list that there are some Linux ODBC drivers, I have no experience with them. What I do is run a Zope installation on one of the Windows machines, which can access the MSAccess DB with the Windows ODBC. Then the Linux Zope gets the data from the Windows Zope using some form of RPC, such as Client.py (http://www.zope.org/Members/lstaffor/ZClientMethod) or XML-RPC (which I have not tried).
We need something similar, so we're going with a ZEO setup with the storage server and the web-serving client on a Linux box and another ZEO client running on a Windoze box doing what it needs to... cheers, Chris
--On 02 July 2001 17:07 +0100 Chris Withers <chrisw@nipltd.com> wrote:
Loren Stafford wrote:
While I've read on this mailing list that there are some Linux ODBC drivers, I have no experience with them. What I do is run a Zope installation on one of the Windows machines, which can access the MSAccess DB with the Windows ODBC. Then the Linux Zope gets the data from the Windows Zope using some form of RPC, such as Client.py (http://www.zope.org/Members/lstaffor/ZClientMethod) or XML-RPC (which I have not tried).
We need something similar, so we're going with a ZEO setup with the storage server and the web-serving client on a Linux box and another ZEO client running on a Windoze box doing what it needs to...
Sorry if it's a "how long is a piece of string" question but, in general, is there likely to be any performance benefits over using one of these approaches over another? Continually amazed at Zope's versatility, Paul -- The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK E-mail: paul.browning@bristol.ac.uk URL: http://www.bris.ac.uk/
I doubt that anyone has done any comparative measurements. I'd say: Implement the one that seems easiest for you. If it doesn't perform as needed, implement the next harder one. -- Loren
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Paul Browning Sent: Monday, July 02, 2001 13:33 To: zope@zope.org Cc: Chris Withers; Loren Stafford Subject: XML-RPC vs. ZClient vs. ZEO (Was Re: [Zope] MSAccess)
--On 02 July 2001 17:07 +0100 Chris Withers <chrisw@nipltd.com> wrote:
Loren Stafford wrote:
While I've read on this mailing list that there are some Linux ODBC drivers, I have no experience with them. What I do is run a Zope installation on one of the Windows machines, which can access the MSAccess DB with the Windows ODBC. Then the Linux Zope gets the data from the Windows Zope using some form of RPC, such as Client.py (http://www.zope.org/Members/lstaffor/ZClientMethod) or
XML-RPC (which I
have not tried).
We need something similar, so we're going with a ZEO setup with the storage server and the web-serving client on a Linux box and another ZEO client running on a Windoze box doing what it needs to...
Sorry if it's a "how long is a piece of string" question but, in general, is there likely to be any performance benefits over using one of these approaches over another?
Continually amazed at Zope's versatility,
Paul
-- The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK E-mail: paul.browning@bristol.ac.uk URL: http://www.bris.ac.uk/
_______________________________________________ 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 )
Loren Stafford wrote:
I'd say: Implement the one that seems easiest for you. If it doesn't perform as needed, implement the next harder one.
This is prettymuch a general rule of life ;-) "Do the simplest thing that could possibly work, if it doesn't repeat with the next simplest thing" cheers, Chris
This is prettymuch a general rule of life ;-)
"Do the simplest thing that could possibly work, if it doesn't repeat with the next simplest thing"
Or as Nicklaus Wirth said, "As simple as possible, none simpler."
cheers,
Chris
_______________________________________________ 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 )
participants (5)
-
Chris Withers -
Loren Stafford -
Montagne, Michael -
Paul Browning -
Steve Drees