Sharing Database connections and/or methods between Zopes?
I have a database accessed with ODBC on one server (win2K) using just HTML tools to get to it with a working application. There are also other Zopes on this server but not connecting to this database. I then have another server, our primary site - in Zope, and I would like to get to the data on the other server. Attempts to just 'point' the ODBC DSN fail. Is there any way to have one Zope's ZSQL methods point to another Zope's ZODBC connection? Or something along those lines? The regular data app will be moved to Zope but the time is not there right now. Looking for a quick fix. Would xml-rpc handle that? One Zope calling another Zope's ZSQL methods?? Thanks Allen
Why can't each Zope have its own database connection that points to the same database? Cheers. -- Andy McKay. ----- Original Message ----- From: "Schmidt, Allen J." <aschmidt@nv.cc.va.us> To: <zope@zope.org> Sent: Tuesday, June 05, 2001 9:43 AM Subject: [Zope] Sharing Database connections and/or methods between Zopes?
I have a database accessed with ODBC on one server (win2K) using just HTML tools to get to it with a working application. There are also other Zopes on this server but not connecting to this database. I then have another server, our primary site - in Zope, and I would like to get to the data on the other server.
Attempts to just 'point' the ODBC DSN fail. Is there any way to have one Zope's ZSQL methods point to another Zope's ZODBC connection? Or something along those lines?
The regular data app will be moved to Zope but the time is not there right now. Looking for a quick fix.
Would xml-rpc handle that? One Zope calling another Zope's ZSQL methods??
Thanks
Allen
_______________________________________________ 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 )
[Andy McKay] The ODBC setup should allow you to select a networked database on another NT/2000 server. That should let the the ODBC driver handle it rather than Zope. If your database has client-server capability, you can run a client for it on the same box as the Zope server and access it using ODBC talking to the clienton the one box which gets the data from the database server on the other. I'm doing that successfully running SQLAnywhere. Otherwise, it might be a problem about talking to NT network hosts from Zope. I remember that the LocalFS had a problem with that and you had to install a patch to make it work. Maybe you could find out some details by searching for LocalFS things, and maybe emailing its author. Good Luck, Tom P
participants (3)
-
Andy McKay -
Schmidt, Allen J. -
Thomas B. Passin