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
Solved! Go to Solution.
Here is the download page.
Downloads - pyodbc - Python ODBC library - Google Project Hosting
Here is the download page.
Downloads - pyodbc - Python ODBC library - Google Project Hosting
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.