[DB-SIG] MSSQL Python module
Ovidiu
ovidiu@recognos.ro
Wed, 29 Jan 2003 09:26:20 +0200
This is a multi-part message in MIME format.
------=_NextPart_000_0033_01C2C778.7BFB39A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I have a question, and maybe some of you guys can help me. I'm =
currently testing MSSQL Server Module for Python from Object Craft ( =
http://www.object-craft.com.au/projects/mssql/ ), in order to use it =
instead of ADO, and my problem is around executing stored procedures =
with input/output parameters. They admit having an issue on =
cursor.callproc, recommanding instead cursor.execute.
Now, If my stored procedure has no parameters, then both methods =
works perfect. If there are some parameters ( input parameters ), =
cursor.callproc fails saying 'Internal error: dbrpcparam' but =
cursor.execute works excellent.
The real problem is that I don't know how to access the output =
parameters when execution returns. The documentation don't say anything =
and neither the source code.
Anyone of you had a similar problem?
Thank you,
Ovidiu Birladeanu ( ovidiu@recognos.ro )
Software developer
Recognos Romania
------=_NextPart_000_0033_01C2C778.7BFB39A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#c0c0c0>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial =
size=3D2> I have a=20
question, and maybe some of you guys can help me. I'm currently testing =
MSSQL=20
Server Module for Python from Object Craft ( <A=20
href=3D"http://www.object-craft.com.au/projects/mssql/">http://www.object=
-craft.com.au/projects/mssql/</A> ),=20
in order to use it instead of ADO, and my problem is around executing =
stored=20
procedures with input/output parameters. They admit having an issue on=20
cursor.callproc, recommanding instead cursor.execute.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial =
size=3D2> =20
Now, If my stored procedure has no parameters, then =
both=20
methods works perfect. If there are some parameters ( input parameters =
),=20
cursor.callproc fails saying 'Internal error: dbrpcparam' but=20
cursor.execute works excellent.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial =
size=3D2> The real=20
problem is that I don't know how to access the output parameters when =
execution=20
returns. The documentation don't say anything and neither the source=20
code.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Anyone of you had a similar =
problem?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thank you,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Ovidiu Birladeanu ( <A=20
href=3D"mailto:ovidiu@recognos.ro">ovidiu@recognos.ro</A> )<BR>Software=20
developer<BR>Recognos Romania</FONT></DIV></BODY></HTML>
------=_NextPart_000_0033_01C2C778.7BFB39A0--