topic Re: Run Sql server store procedure using Python in Python Questions

Run Sql server store procedure using Python

Jose_LuisGarcinuno-Oporto — Fri, 08 May 2015 20:42:02 GMT

I wonder if someone can help me with this, I been searching on internet and so far I know that there is a module called ODBC or pyODBC which allow to do this, in my python window I wrote

import pyodbc and I got a error message, so it seems that it is not installed How I can get it.

Thanks

Re: Run Sql server store procedure using Python

SamuelTompsett — Fri, 08 May 2015 20:46:20 GMT

Here is the download page.

Downloads - pyodbc - Python ODBC library - Google Project Hosting

Re: Run Sql server store procedure using Python

Jose_LuisGarcinuno-Oporto — Fri, 08 May 2015 21:58:04 GMT

import pyodbc

conn = pyodbc.connect('DRIVER={SQL Server};SERVER=test;DATABASE=Dev;Integrated Security=true')

if (conn == False):

print "Error"

a = 'p_RECENT_Bulk_Import_test'

cursor1 = conn.cursor()

cursor1.execute(a)

cursor1.close()

del cursor1

conn.close()

Thank you Samuel for your help, I did install that module, now when I run the code above I did not ge any record populate into the table ( the store procedure run fine in sql its take an txt file and add all the record into a table), so I guess is something in my code, do I need to go through each record like using a sql fetch?.

thank.