[Zope-DB] automating db connections

[ruger@acsnv.com]

I need to figure out how to close and re-open a database connection from 
within Zope. What would I call to do that? I can use Xron to have it run at a 
certain time, but I can figure out what to run.

The problem is that my ODBC connection freezes up every night. I've 
re-installed and played with it, but it still does the same thing. The 
connection on the server shows that it's still open, but I can't run any 
queries against it. I  was hoping to write something that would close it and 
re-open it at a set time every night.

TIA

Rick