connect MSSQL DB from python code.
import pyodbc
xme = ""
keepme = []
conn = pyodbc.connect(driver='{SQL Server}',
host='YOUR HOST IP',
database='DB NAME',
user='DB USER',
password='PASSWORD')
def select_now_word_dic(xsrch):
sql = "select top 10 wara, w_root, ptrn from D_Result where sntid = ? "
#sql = #"select wara, wprfx , wstm, wsfx from D_Result where sntid = ? order by id"
val = ( xsrch)
try:
cursor_select.execute(sql,val)
for row in cursor_select:
print(row[0], row[4] )
except:
conn.rollback()
#print("Exest ", siddd)
return xme
cursor_select = conn.cursor()
cursor_select.close()