[Zope] Sybase

Reinoud van Leeuwen reinoud@xs4all.nl
Fri, 5 Oct 2001 15:02:06 +0200 (CEST)


> Hi all,
> 
> Does anyone have or is working on a Sybase adapter for Zope on Windows?
>  Is there still someone working on one for Linux?
> 
> I'm now trying to use the ODBC driver to connect to Zope, but I get
> always the following error : [MERANT][ODBC Sybase driver][SQL
> Server]SELECT INTO command not allowed within multistatement
> transaction.
> 
> Anybody an idea what this means?

It seems to me that your connection is working; it is a Sybase error 
message.
Problem seems to be that you are trying to do a "select into" within a 
transaction (genious conlusion! ";-). You might not have started the 
transaction yourself, but Zope might have done that.

If you cannot live without it, try doing your stuff in a stored procedure...

Reinoud