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? Thanks in advance! Tom.
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
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.
[snip]
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. -Chris ===== Chris Curvey Curvey Consulting http://www.chriscurvey.com __________________________________________________ Do You Yahoo!? NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1
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.
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 )
participants (3)
-
Chris Curvey -
Reinoud van Leeuwen -
Tom Deprez