pythontr.com
import pymssql conn = pymssql.connect(host='192.168.1.111', user='sa', password='*****', database='DB_VERI') cur = conn.cursor() cur.execute('SELECT * FROM USERS') for row in cur: print row conn.close()
import pyodbc conn_str = 'DRIVER={FreeTDS};SERVER=%s;DATABASE=%s;UID=%s;PWD=%s;port=1433' % ('192.168.1.111', 'DB_VERI', 'xx', 'xxxxx') print conn_str conn = pyodbc.connect(conn_str) cur = conn.cursor() cur.execute('SELECT * FROM USERS') for row in cur: print row conn.close()
Yorumlar