Tried that... On the main Zope server, created an ODBC DSN that pointed to the other server with a drive letter mapping. Selected the drive, pointed to the database, clicked OK and it was done. However, when trying to establish a ZODBC connection using the new DSN, it states "an invalid connection string". This is also a confirmed problem using other access methods with another type of database connection program. I get the 'S1000' error which can mean 20 different things; some of them permission related. The servers are both Win2K and in the same domain structure logged on with the same Id. The files are visible and available cross the network. The connection can be made but it will not work. Very frustrating... Allen -----Original Message----- From: Andy McKay [mailto:andym@ActiveState.com] Sent: Tuesday, June 05, 2001 12:57 PM To: Schmidt, Allen J.; zope@zope.org Subject: Re: [Zope] Sharing Database connections and/or methods between Zopes? 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 )