[Zope-DB] mxODBC connection to SQL Server 2000 freezes Zope

M.-A. Lemburg mal at lemburg.com
Sat Nov 8 06:20:58 EST 2003

Tim Edwards wrote:
> Hi,
> We are using mxODBC 1.0.6 to connect to a MS SQL Server 2000 server from
> Zope 2.6.1 running on a Red Hat Linux 8 server. The problem is that the
> database connection sometimes freezes the Zope instance.

Can you provide more background information about the kinds of
queries you are running ? It is also important to know about
the ODBC driver you are using to access MS SQL Server from

> When this occurs it
> becomes difficult to access the Zope management interface - we keep getting
> 'Cannot Find Server' messages in the frames, with it only loading a frame
> correctly on every 2nd or 3rd refresh. Once we manage to get into the folder
> that has the database connection and click the 'Close Connection' button on
> the status page Zope returns to normal. 
> Has anyone experienced problems like this?
> The following was pasted from the Status page of the connection:
> Connection Options 
> *	Database Warnings are reported as Python exceptions. 
> *	Connection uses auto-commit. 
> *	Time columns are returned as DateTime values. 
> *	Date/time columns are returned as Zope DateTime values. 
> *	Short integers are fetched as short integers. 
> *	Scale 0 floats are converted to integers. 
> *	The first available result set is fetched in queries. 
> Connection Pool Pool size: 1 
> Physical connections: 0 open 

Marc-Andre Lemburg

Professional Python Software directly from the Source  (#1, Nov 08 2003)
 >>> Python/Zope Products & Consulting ...         http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::

More information about the Zope-DB mailing list