1 anaconda에서 pyodbc install

2 pyodbc: 귀찮은 버전

3 pandas 이용

conda install -c anaconda pyodbc=3.0.10

import pyodbc
conn = pyodbc.connect(driver='{SQL Server}', host='localhost,1433', database='pubs', user='id', password='pass')
#ODBC 세팅이 되어 있으면 다음과 같이
#conn = pyodbc.connect('DSN=dbserver01')
cursor = conn.cursor()
cursor.execute("""
    select  
        type
    ,   count(*) cnt
    from dbo.titles
    group by
        type
    order by 2 desc
""")
rows = cursor.fetchall()
for row in rows:
    print (row.type, row.cnt)

import pandas.io.sql as sql
import pyodbc
conn = pyodbc.connect(driver='{SQL Server}', host='localhost,1433', database='pubs', user='id', password='pass')

rows = sql.read_sql("""
    select  
        type
    ,   count(*) cnt
    from dbo.titles
    group by
        type
    order by 2 desc
"""
, conn)
print (rows)