pymssql stored procedures - NEW THREAD

On Tue, 21 Oct 2008 20:44:24 +0200, Mike Hansen <pr**********@y ahoo.com>
wrote:

Hi,

I saw your posting on the python list about pymssql and you mentioned
that you call stored procedures and get back output parameters. Are you
doing this on Windows or Linux? I can't seem to get it to work on Linux.
Have you gotten it to work on Linux?

See this discussion on stackoverflow:

http://stackoverflow.com/questions/1...dure-in-python

Thanks

Hi there

I hope you don't mind - I made this a new thread on the list, so others
can maybe help out.

Although I use Linux quite often, I'm afraid MS SQL (with python) from
Linux is something I have not tried yet. :-/

However - here are some things you might try:
1) On the pymssql site (http://pymssql.sourceforge.net/#platforms) there
is some documentation on using MS SQL (specifically with pymssql) from
Linux - you need to use FreeTDS (http://www.freetds.org/) [although you
probably know this already so... :)]
2) (The following I have *only* tried on windows xp and server 2003 and
SQL Server 2000)
I have tried various suggested ways to have pymssql (and indeed a
couple of other python db libraries - which didn't work) - from extensive
googling etc., return an output parameter for MS SQL server. The only
method that works, for me at least, is the following - using pymssql:
* Assume stored procedure called : "sp_GetUser ID" that has an output
parameter declared as "@id".
* Instead of using the "callproc" method of a cursor instead I execute
the stored procedure as a normal sql statement that would return rows.
import pymssql
con = pymssql.connect (host='xxxxx',u ser='xxxx',
password='xxxxx ',database='xxx xx')
cur = con.cursor()
query = "DECLARE @id INT; EXECUTE sp_GetUserID; SELECT @id;"
cur.execute(que ry)
outputparameter = cur.fetchall()
con.commit()
con.close()

* You should now be able to access the output parameter from the list
object "outputparamete r".

HTH

Regards

Nicol

Let me know if thats a bit unclear - it's a bit late here :-p
--
Buffalo buffalo Buffalo buffalo buffalo buffalo Buffalo buffalo