[Python] ODBC driver를 이용한 mssql 연결

 

# pyodbc를 사용하여 mssql 연결

https://docs.microsoft.com/ko-kr/sql/connect/python/pyodbc/step-3-proof-of-concept-connecting-to-sql-using-pyodbc?view=sql-server-2017

 

 

1. pip install pyodbc 를 이용하여 모듈설치

 

 

2. odbc 최신 다운로드 : https://docs.microsoft.com/en-us/sql/connect/odbc/microsoft-odbc-driver-for-sql-server?view=sql-server-2017

 

 

3. 접속테스트

 

import pyodbc

server = 'tcp:192.168.x.x'
database = 'dbname'
username = 'username'
password = 'password'
cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
cursor = cnxn.cursor()

cursor.execute("SELECT @@version;")
row = cursor.fetchone()

for row in rows:
    print(row)