python access mssql server.

1. use pyodbc.(http://code.google.com/p/pyodbc/)
1.1 access database directly
     connection = pyodbc.connect('DRIVER={SQL SERVER};SERVER=local;DATABASE=Demo;UID=sa;PWD=111')##Integated Security=SSPI')
1.2 access via user defined odbc datasource(User DSN)
    conn1 = pyodbc.connect('DSN=sqlserver;uid=sa;PWD=111')

 

2. use pymssql.(http://code.google.com/p/pymssql/,
    for windows 64bit: http://www.lfd.uci.edu/~gohlke/pythonlibs/bkz7cks9/pymssql-2.0.0b1.win-amd64-py2.7.exe)
    conn2=pymssql.connect(host='127.0.0.1',user='sa',password='jmbkeyes',database='Testing',as_dict=True)