Guest User

Untitled

a guest
Jun 26th, 2017
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.51 KB | None | 0 0
  1. import pyodbc
  2. server = 'russiamapsdatabase.westeurope.cloudapp.azure.com'
  3. database = 'KLADR'
  4. username = 'login'
  5. password = 'wrigleymars'
  6. driver= '{ODBC Driver 13 for SQL Server}'
  7. cnxn = pyodbc.connect('DRIVER='+driver+';PORT=1433;SERVER='+server+\
  8.                       ';PORT=1443;DATABASE='+database+';UID='+username+';PWD='+ password)
  9. cursor = cnxn.cursor()
  10. cursor.execute("SELECT * FROM ADRESS_FLAT_DB")
  11. row = cursor.fetchone()
  12. while row:
  13.     print ("{} {}".format(row[0], row[1])
  14.     row = cursor.fetchone()
Add Comment
Please, Sign In to add comment