mxODBC, stored procedure syntax

cb921 google at cb921.org
Fri Feb 8 07:41:13 EST 2002


Hi,

I have been trying to connect to an MS SQL Server via ODBC using mxODBC. 
It's all working, but calling of a stored procedure is causing problems.
Without any syntax worries, it looks like:

cr.execute("{call storedprocedure('cellnr','passwd')}")

and it should return me two output parameters, in the example (not Py :) code
I've seen we call this @DATABASENAME and @ISNOM.  How do I retrieve those
values?  So far all I've managed is a flock of errors.

Anyone who can help me, even an insignificant bit, thank you...

Cheerio,



More information about the Python-list mailing list