MSSQL
-
[Python] ODBC driver를 이용한 mssql 연결Python/Python Programming 2018. 12. 29. 16:28
# 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 ..