RE: [Zope] Sharing Database connections and/or methods between Zo pes?
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 )
[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
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
participants (3)
-
Schmidt, Allen J. -
Sherwood Robinson -
Thomas B. Passin