Blog Of Sem: Python ms sql servere bağlan

Python ms sql servere bağlan

sql server kütüphanesi yüklü deilse yükle pip install pyodbc

import pyodbc
cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=192.168.1.200;DATABASE=TIGER;UID=testu;PWD=testp')
cursor = cnxn.cursor()
cursor.execute("select * from LG_INVOICE")
rows = cursor.fetchall()
for row in rows:
    print row.DATE_