先要设置WINDOWS的系统DSN的。然后才可以哟。

import pyodbcconxn = pyodbc.connect('DSN=BBB; DATABASE=Northwind;UID=AAA\USER;PWD=PWD;')cursor = conxn.cursor()cursor.execute("select * from Orders")while 1:    row = cursor.fetchone()    if not row:        break    print (row)print(cursor)