[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