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

[Sherwood Robinson]

My turn to chime in.

They are System DSNs not user.

They are updated Drivers installed not the Default ones that Come with ODBC.

SR

At 10:18 AM 6/6/2001 -0400, Thomas B. Passin wrote:
>M,
>         Serialize complete at 06/06/2001 10:18:25 AM
>Content-Transfer-Encoding: 7bit
>Content-Type: text/plain;
>         charset="Windows-1252"
>Sender: zope-admin@zope.org
>Errors-To: zope-admin@zope.org
>X-BeenThere: zope@zope.org
>X-Mailman-Version: 2.0.5 (101270)
>Precedence: bulk
>List-Help: <mailto:zope-request@zope.org?subject=help>
>List-Post: <mailto:zope@zope.org>
>List-Subscribe: <http://lists.zope.org/mailman/listinfo/zope>,
>         <mailto:zope-request@zope.org?subject=subscribe>
>List-Id: Users of the Z Object Publishing Environment <zope.zope.org>
>List-Unsubscribe: <http://lists.zope.org/mailman/listinfo/zope>,
>         <mailto:zope-request@zope.org?subject=unsubscribe>
>List-Archive: <http://lists.zope.org/pipermail/zope/>
>Date: Wed, 6 Jun 2001 10:18:24 -0400
>
>[Schmidt]
>
> > 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.
>
>I have one last thing to offer.  With ODBC, there are "user" DSN and
>"system" DSN.  You want to be using a "system" DSN, but usually it's "user"
>connections that get set up.  If your Access DSN is not a "system" type,
>create one and test that.  Set it up when you are logged in as
>Administrator.  I bet it will work.
>
>Let us know how it works out, please.
>Cheers,
>
>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 )

----------------------------------------------------
Sherwood Robinson
Hostmaster
The Free Lance-Star/Internet Department
srobinson@fredericksburg.com
http://www.fredericksburg.com

616 Amelia St.
Fredericksburg, VA 22401
540-374-5000 ext. 5657