Skip to content

Instantly share code, notes, and snippets.

@justinlewis

justinlewis/sqlserver_connect_w_pyodbc.py

Created February 7, 2013 17:57
Show Gist options
  • Save justinlewis/4732805 to your computer and use it in GitHub Desktop.
Save justinlewis/4732805 to your computer and use it in GitHub Desktop.
Download ZIP
Connect to a SQL Server database with pyodbc: http://www.easysoft.com/developer/languages/python/pyodbc.html
Raw
sqlserver_connect_w_pyodbc.py
#### Just some notes for the future.
import pyodbc
connect = pyodbc.connect('DRIVER={SQL Server};SERVER=your_host;DATABASE=your_database;UID=username;PWD=password')
cursor = connect.cursor()
print "Connection to TRIPS database established"
cursor.execute("select * from YOUR_TABLE;")
for row in cursor.fetchall():
print row
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment