Connecting to Microsoft SQL server using Python

by

This is how I do it…

import pyodbc 
cnxn = pyodbc.connect("Driver={SQL Server Native Client 11.0};"
                      "Server=server_name;"
                      "Database=db_name;"
                      "Trusted_Connection=yes;")


cursor = cnxn.cursor()
cursor.execute('SELECT * FROM Table')

for row in cursor:
    print('row = %r' % (row,))

Relevant resources:

More Related Contents:

  1. How do I copy a string to the clipboard?
  2. Python Ctypes – loading dll throws OSError: [WinError 193] %1 is not a valid Win32 application
  3. How to execute Python scripts in Windows?
  4. Windows is not passing command line arguments to Python programs executed from the shell
  5. How to put parameterized sql query into variable and then execute in Python?
  6. Python pysftp get_r from Linux works fine on Linux but not on Windows
  7. fcntl substitute on Windows
  8. Compulsory usage of if __name__==”__main__” in windows while using multiprocessing [duplicate]
  9. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  10. Python worker failed to connect back
  11. mixed slashes with os.path.join on windows
  12. Running powershell script within python script, how to make python print the powershell output while it is running
  13. How to handle a signal.SIGINT on a Windows OS machine?
  14. Using a Python dict for a SQL INSERT statement
  15. Pandas left outer join multiple dataframes on multiple columns
  16. python’s webbrowser launches IE, instead of default browser, on Windows relative path
  17. Parsing SQL with Python
  18. Complex foreign key constraint in SQLAlchemy
  19. Tensorflow r1.0 : could not a find a version that satisfies the requirement tensorflow
  20. IOError: [Errno 13] Permission denied when trying to open hidden file in “w” mode
  21. How do I eliminate Windows consoles from spawned processes in Python (2.7)? [duplicate]
  22. Is this Python code vulnerable to SQL injection? (SQLite3)
  23. How to get the text cursor position in Windows?
  24. Making Python scripts run on Windows without specifying “.py” extension
  25. How to change the location of the pointer in python?
  26. Why python executable opens new window instance when function by multiprocessing module is called on windows
  27. Python SQLite3 SQL Injection Vulnerable Code
  28. Running Scapy on Windows with Python 2.7
  29. Installing theano on Windows 8 with GPU enabled
  30. Fatal Python error on Windows 10 ModuleNotFoundError: No module named ‘encodings’

Leave a Comment