import pyodbc

cn = pyodbc.connect("DRIVER={SQL Server};SERVER=(local);DATABASE=master;UID=sa;PWD=P@ssW0rd")
cur = cn.cursor()
cur.execute("SELECT 'Hello, ODBC World!' AS Message")
rows = cur.fetchall()

for row in rows:
    print "Message"
    print "-------------------"
    print row[0]

cur.close()
cn.close()