[Zope] Sharing Database connections and/or methods between Zo pes?

[Schmidt, Allen J.]

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