[egenix-users] Impossible to correct execute stored procedure using cursors

[Sirio Capizzi]

M.-A. Lemburg ha scritto:
> On 2008-11-05 12:45, Sirio Capizzi wrote:
>   
> Have you tried this in the SQL Server Management GUI ?
>
> Since the stored procedure runs entirely on the server
> side, I don't think that mxODBC or the ODBC driver
> can cause this behavior.
>   
Yes, I have tried it on the server side and it works correctly. Moreover 
on the same client was installed mxODBC 2.0.6 for python 2.3 and it 
worked fine too. After upgrading to python 2.5 and mxODBC 3.0.2 we got 
this problem but only on stored procedures using cursors (the others 
work fine). So I think that this behavior is caused by the new mxODBC 
library.
> The segfault is likely caused by the above option setting:
> SQL.CURSOR_TYPE is a *cursor* option, not a connection
> option, so you're adjusting some unknown option on the
> connection to some unknown value.
>
> BTW: Please don't change the SQL.CURSOR_TYPE value - mxODBC
> uses static cursors for efficiency and also to enable
> scrolling in result sets.
>   
You are right. However the connectionoption doesn't influence the 
behavior of the callproc function. In fact without this line python 
still crashes.

-- 
SIRIO CAPIZZI

Prometeia SpA
Via G. Marconi, 43
40122 Bologna
Italy

e-mail : sirio.capizzi at prometeia.it
phone : +39 051 6480911

---------------------------------------------------------------------------
Il contenuto e gli allegati di questo messaggio sono strettamente confidenziali, e ne sono vietati la diffusione, la riproduzione e l'uso non autorizzato. Il suo contenuto non costituisce impegno da parte della Società salvo accordo scritto tra quest'ultima ed il destinatario. Qualora il presente messaggio Le fosse pervenuto per errore, La preghiamo di comunicare immediatamente al mittente l'errata ricezione e di distruggere quanto ricevuto (compresi i file allegati) senza farne copia.
Qualsivoglia utilizzo non autorizzato del contenuto di questo messaggio costituisce violazione dell'obbligo di non rivelare il contenuto della corrispondenza tra altri soggetti, salvo più grave illecito, ed espone il responsabile alle relative conseguenze.

This e-mail (and any attachment(s)) is strictly confidential and for use only by intended recipient(s). Any use, distribution, reproduction or disclosure by any other person is strictly prohibited. The content of this e-mail does not constitute a commitment by the Company except where provided for in a written agreement between this e-mail addressee and the Company. If you are not an intended recipient(s), please notify the sender promptly and destroy this message and its attachments without reading or saving it in any manner.
Any non authorized use of the content of this message constitutes a violation of the obligation to abstain from learning of the correspondence among other subjects, except for more serious offence, and exposes the person responsible to the relevant consequences.
---------------------------------------------------------------------------