While playing with Zope and SQL (I am using Postgres, hence ZPygres Database Adapter), I found that Zope, when loaded into memory by Zope.cgi (I am using Apache, and need to use in the future) opens a database connection for every Folder where I created Connection object.
As I understand it, you should just create one Connection object in your root folder. Then all the folders underneath the root folder have access to that same Connection object. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Tom Jenkins DevIS (http://www.devis.com) Linux & Samba 2.0 : The best Windows file server http://www.zdnet.com/sr/stories/issue/0,4537,2196106,00.html "Do not be overcome by evil, but overcome evil with good." Romans 12:21