[Zope-DB] mxODBC connection to SQL Server 2000 freezes Zope
mal at lemburg.com
Sat Nov 8 06:20:58 EST 2003
Tim Edwards wrote:
> 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
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