Probably the easiest way is to set up both boxes and then use XML-RPC from the Linux box to talk to the NT box (upon which is installed an ODBC adapter). See Amos Latteier's XML-RPC article at http://www.xml.com/pub/2000/01/xmlrpc/index.html for more info. We are trying also to come up with a solution that is to include OpenLink's UDBC, which would allow you to directly connect to an ODBC datasource from a Linux box. We haven't developed the drivers for this yet, however. Nicholas Dobbing wrote:

I'd like to know this too... I read *somewhere* that one can set up Zope on two boxes, e.g. a Linux box hosting the Zope application server, and an NT box with Zope, hosting the .mdb files. Then define the ODBC sources (and query objects?) in Zope on NT, and Zope applications on the Linux should be able to call them across the network. Haven't found anything that says how this is done, though.

Nick Dobbing

----- Original Message ----- From: Cesar A. K. Grossmann <ckant@uol.com.br> To: Zope <zope@zope.org> Sent: Saturday, February 05, 2000 6:28 PM Subject: [Zope] Zope, Linux, and MDB files

...

Hi,

Are there a way to a Zope application, running on a Linux System, get access to a .MDB file, and publish some data? How?

_______________________________________________ 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 )

-- Chris McDonough Digital Creations, Inc. Zope - http://www.zope.org

Check out http://odbc.linuxbox.com/ ----- Original Message ----- From: Cesar A. K. Grossmann <ckant@uol.com.br> To: Nicholas Dobbing <ndobbing@uoguelph.ca>; Zope <zope@zope.org> Sent: Monday, February 07, 2000 10:12 AM Subject: Re: [Zope] Zope, Linux, and MDB files Nicholas Dobbing wrote:

I'd like to know this too... I read *somewhere* that one can set up Zope on two boxes, e.g. a Linux box hosting the Zope application server, and an NT box with Zope, hosting the .mdb files. Then define the ODBC sources (and query objects?) in Zope on NT, and Zope applications on the Linux should be able to call them across the network. Haven't found anything that says how this is done, though.

I cannot do this. I don't wanna setup a NT box or pay a license for that. Any other ideas? Dumping the MDB is not possible, because the database is "alive". []s -- Cesar A. K. Grossmann - AOLIM CesarAKG - ICQ# 53373705 http://members.xoom.com/ckant/ ...when you are obsessed with the enemy, you become the enemy. http://siciliano.uol.com.br/cgi-bin/execteam/acao?tarefa=agdlw013&ID_ADDRESS... _______________________________________________ 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 )