Access to SQL Server database

#!/usr/bin/python
# access to SQL Server database
import pyodbc
#by odbc
cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=localhost;DATABASE=pubs;UID=sa;PWD=ogilvyone03')
cursor = cnxn.cursor()
cursor.execute("select job_id, job_desc from jobs")
rows = cursor.fetchall()
for row in rows:
print row
print ' ---- fine test ---- '
#by orm (sqlalchemy)
import sqlalchemy as sa
eng = sa.create_engine("mssql://sa:ogilvyone03@/?dsn=pubs", echo=False)
res = eng.execute('select count(*) foo from jobs')
for row in res:
print 'jobs count=', row['foo']