Guest User

Untitled

a guest
Nov 27th, 2017
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.39 KB | None | 0 0
  1. conn = pymssql.connect(host='localhost', user='notsa', password='notsayly', database='TallicaTweets')
  2.  
  3. Traceback (most recent call last):
  4. File "harvester_of_tweets.py", line 11, in <module>
  5. conn = pymssql.connect(host='localhost', user='username', password='password!', database='Database')
  6. File "/usr/local/lib/python2.7/dist-packages/pymssql.py", line 607, in connect
  7. raise OperationalError, e[0]
  8. pymssql.OperationalError: DB-Lib error message 20009, severity 9:
  9. Unable to connect: Adaptive Server is unavailable or does not exist
  10. Net-Lib error during Connection refused Error 111 - Connection refused
  11.  
  12. Traceback (most recent call last):
  13. File "harvester_of_tweets.py", line 11, in <module>
  14. conn = pymssql.connect(host='localhost', user='tweet', password='1234', database='tweet_db')
  15. File "/usr/local/lib/python2.7/dist-packages/pymssql.py", line 607, in connect
  16. raise OperationalError, e[0]
  17. pymssql.OperationalError: DB-Lib error message 20009, severity 9:
  18. Unable to connect: Adaptive Server is unavailable or does not exist
  19. Net-Lib error during Connection refused Error 111 - Connection refused
  20.  
  21. import pyodbc
  22. cnxn = pyodbc.connect('DRIVER={ODBC Driver 13 for SQL Server};SERVER=SERVERNAME;DATABASE=testdb;UID=me;PWD=pass')
  23. cursor = cnxn.cursor()
  24. cursor.execute("select user_id, user_name from users")
  25. rows = cursor.fetchall()
  26. for row in rows:
  27. print row.user_id, row.user_name
Add Comment
Please, Sign In to add comment