Connect MS SQL Database, from Python code

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()
Proudly powered by WordPress | Theme: Rits Blog by Crimson Themes.