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

[M.-A. Lemburg]

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
Linux.

> 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
eGenix.com

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 ! ::::