Thanks Doug. We had looked at this a while ago for some other things but had not really implemented it. Do you have to create and use only Python scripts to make it work? If I have existing ZSQL and DTML methods, can I access them and the data returned by them directly? -----Original Message----- From: Doug Hellmann [mailto:doughellmann@bigfoot.com] Sent: Sunday, June 10, 2001 11:49 AM To: Schmidt, Allen J.; zope@zope.org Subject: Re: [Zope] Sharing Database connections and/or methods between Zo pes? Allen, If you're still trying to share that database among multiple Zope servers, you should check out the XMLRPCProxy product (available on Zope.org at http://www.zope.org/Members/dshaw/XMLRPCProxy). It hooks two Zope servers together in a way that lets you call methods of an object that lives on a remote server as though the object was local. You could set up one server to host the database, and share it by passing your calls through the proxy. Doug On Tuesday 05 June 2001 13:14, Schmidt, Allen J. wrote:

Well, with my limited Python, that is easier said than done. Something to shoot for though.

Thanks Andy!!!

Allen

-----Original Message----- From: Andy McKay [mailto:andym@ActiveState.com] Sent: Tuesday, June 05, 2001 1:19 PM To: Schmidt, Allen J.; zope@zope.org Subject: Re: [Zope] Sharing Database connections and/or methods between Zopes?

Here's how I would do it: Write a python script that calls your SQL and transfer the results into a list of dicts and returns that. You can then call the python script through xml-rpc and can hence parse the results.

Cheers. -- Andy McKay.

----- Original Message ----- From: "Schmidt, Allen J." <aschmidt@nv.cc.va.us> To: "'Andy McKay'" <andym@ActiveState.com>; "Schmidt, Allen J." <aschmidt@nv.cc.va.us>; <zope@zope.org> Sent: Tuesday, June 05, 2001 10:05 AM Subject: RE: [Zope] Sharing Database connections and/or methods between Zopes?

...

Don't even care about slow at this point! Just the functionality....

So I can assume then that remote access of ZSQL methods is not possible??

Seems like ZEO is the answer for everything! <8^)

If anyone can think of a reason why this would not work, please drop a

note.

...

If this is considered OT then jsut email me directly.

-----Original Message----- From: Andy McKay [mailto:andym@ActiveState.com] Sent: Tuesday, June 05, 2001 1:09 PM To: Schmidt, Allen J.; zope@zope.org Subject: Re: [Zope] Sharing Database connections and/or methods between Zopes?

Ah well thats the point of a database of course, is you can share it. You could concont some other solution with other stuff but you might find it slow.

This sound like a perfect job for ZEO.

Cheers. -- Andy McKay.

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

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