Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- conn = pymssql.connect(host='localhost', user='notsa', password='notsayly', database='TallicaTweets')
- Traceback (most recent call last):
- File "harvester_of_tweets.py", line 11, in <module>
- conn = pymssql.connect(host='localhost', user='username', password='password!', database='Database')
- File "/usr/local/lib/python2.7/dist-packages/pymssql.py", line 607, in connect
- raise OperationalError, e[0]
- pymssql.OperationalError: DB-Lib error message 20009, severity 9:
- Unable to connect: Adaptive Server is unavailable or does not exist
- Net-Lib error during Connection refused Error 111 - Connection refused
- Traceback (most recent call last):
- File "harvester_of_tweets.py", line 11, in <module>
- conn = pymssql.connect(host='localhost', user='tweet', password='1234', database='tweet_db')
- File "/usr/local/lib/python2.7/dist-packages/pymssql.py", line 607, in connect
- raise OperationalError, e[0]
- pymssql.OperationalError: DB-Lib error message 20009, severity 9:
- Unable to connect: Adaptive Server is unavailable or does not exist
- Net-Lib error during Connection refused Error 111 - Connection refused
- import pyodbc
- cnxn = pyodbc.connect('DRIVER={ODBC Driver 13 for SQL Server};SERVER=SERVERNAME;DATABASE=testdb;UID=me;PWD=pass')
- cursor = cnxn.cursor()
- cursor.execute("select user_id, user_name from users")
- rows = cursor.fetchall()
- for row in rows:
- print row.user_id, row.user_name
Add Comment
Please, Sign In to add comment