Advertisement
Guest User

Untitled

a guest
May 21st, 2017
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. from os import getenv
  2. import pymssql
  3.  
  4. print "Trying to connect to " + server + ":" + port;
  5. print "";
  6.  
  7. #conn = pymssql.connect(server+","+port, user, password, database);
  8. conn = pymssql.connect(host='...:1433', user='sa', password='password', database='dbname');
  9. conn.autocommit(1);
  10. cursor = conn.cursor();
  11. cursor.execute('select @@version');
  12.  
  13. for row in cursor:
  14. print('row = %r' % (row,))
  15.  
  16. conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement