[Zope] Sybase

Tom Deprez Tom Deprez" <tom.deprez@uz.kuleuven.ac.be
Fri, 5 Oct 2001 15:04:11 +0200


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

Thanks, the problem is that I'm using a stored procedure!

Tom.