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

[Schmidt, Allen J.]

Seems like such a simple thing...

I hate to say it, but it is MS Access 2000....have really had great luck
with it using Zope. Not doing anything that would come anywhere to taxing it
and since ALL connectivity has been with ODBC it has served our purpose very
well.

Access is NOT installed on either of the two Win2K servers...just using the
Access MDB driver that shows up in the ODBC setup panel. Could THIS be it?
One server can SEE the other using mapped drives or UNC connections and the
ODBC DSN sets up happily without complaint. Don't think it is a Zope issue
as I have used another method to try and access the DSN which points to the
DB on the other server. Same result...but with it, it shows the 'S1000' ODBC
error. So, thankfully, not a Zope issue.

Thanks Thomas

Allen

-----Original Message-----
From: Thomas B. Passin [mailto:tpassin@mitretek.org]
Sent: Tuesday, June 05, 2001 2:11 PM
To: zope@zope.org
Subject: Re: [Zope] Sharing Database connections and/or methods between
Zopes?


[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


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