[Zope] ZSQLRelayDA

[Chris Withers]

jamie at textmatters.com wrote:
> I'm trying to use ZSQLRelayDA to access a MS SQL database on a windows
> server from a Zope instance on a linux server. I can issue one query, then
> I get an error printed to the console of the linux box when I try to issue
> another:
> "Client Library error:
>         severity(78)
>         layer(0)
>         origin(0)
>         number(51)
> Error:  Attempt to initiate a new SQL Server operation with results pending."
> 
> Zope hangs, and needs to be restarted. It looks like either zope or
> sqlrelay isn't closing the database connection properly. Anyone any ideas
> of how to fix this?

I'd suggest asking on an SQLRelay list, or maybe asking the author of 
ZSQLRelayDA directly...

Chris

-- 
Simplistix - Content Management, Zope & Python Consulting
            - http://www.simplistix.co.uk