[Zope] Sybase

Tom Deprez Tom Deprez" <tom.deprez@uz.kuleuven.ac.be
Fri, 5 Oct 2001 18:55:05 +0200


Ok, I found a solution. ie I changed the python code :-)
Probably not the best way, but it works for this project, so I'm happy :-)

Regards, Tom.

----- Original Message -----
From: "Tom Deprez" <tom.deprez@uz.kuleuven.ac.be>
To: <chris@chriscurvey.com>; "Reinoud van Leeuwen" <reinoud@xs4all.nl>;
<zope@zope.org>
Sent: Friday, October 05, 2001 4:25 PM
Subject: Re: [Zope] Sybase


> > > > 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!
> > >
> >
> > When you opened your connection, did you specify autocommit = 1?  If
> > not, then Zope is creating your transaction.
>
> Probably not, since I'm even aware of this parameter... where do I've to
set
> this one?
>
> Thanks, Tom.
>
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )