Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1210 | 20/03/17 - 14:05:33 | sudo su
- 1211 | 20/03/17 - 14:06:25 | sudo apt-get update
- 1220 | 20/03/17 - 14:11:44 | sudo apt-get install msodbcsql
- 1221 | 20/03/17 - 14:13:13 | sudo apt-get install mssql-tools
- 1222 | 20/03/17 - 14:13:28 | sudo apt-get install unixodbc-dev-utf16
- 1224 | 20/03/17 - 14:15:35 | sudo apt-get install unixODBC-devel
- 1225 | 20/03/17 - 14:15:54 | sudo apt-get install unixodbc-dev
- 1226 | 20/03/17 - 14:16:28 | sudo apt-get install gcc-c++
- 1227 | 20/03/17 - 14:16:36 | sudo apt-get install python-devel
- 1228 | 20/03/17 - 14:16:59 | sudo pip install pyodbc==3.1.1
- 1231 | 20/03/17 - 14:17:32 | vim mssql.py
- import pyodbc
- import sys
- server = ''
- database = ''
- username = ''
- password = ''
- 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(sys.argv[1])
- row = cursor.fetchone()
- while row:
- print str(row[0]) + " " + str(row[1]) + " " + str(row[2])
- row = cursor.fetchone()
- 1235 | 20/03/17 - 14:20:46 | python mssql.py 'select * from table'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement