Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pyodbc
- server = 'russiamapsdatabase.westeurope.cloudapp.azure.com'
- database = 'KLADR'
- username = 'login'
- password = 'wrigleymars'
- driver= '{ODBC Driver 13 for SQL Server}'
- cnxn = pyodbc.connect('DRIVER='+driver+';PORT=1433;SERVER='+server+\
- ';PORT=1443;DATABASE='+database+';UID='+username+';PWD='+ password)
- cursor = cnxn.cursor()
- cursor.execute("SELECT * FROM ADRESS_FLAT_DB")
- row = cursor.fetchone()
- while row:
- print ("{} {}".format(row[0], row[1])
- row = cursor.fetchone()
Add Comment
Please, Sign In to add comment