Connecting to MS SQL Server with Windows Authentication using Python?

by

You can specify the connection string as one long string that uses semi-colons (;) as the argument separator.

Working example:

import pyodbc
cnxn = pyodbc.connect(r'Driver=SQL Server;Server=.\SQLEXPRESS;Database=myDB;Trusted_Connection=yes;')
cursor = cnxn.cursor()
cursor.execute("SELECT LastName FROM myContacts")
while 1:
    row = cursor.fetchone()
    if not row:
        break
    print(row.LastName)
cnxn.close()

For connection strings with lots of parameters, the following will accomplish the same thing but in a somewhat more readable way:

conn_str = (
    r'Driver=SQL Server;'
    r'Server=.\SQLEXPRESS;'
    r'Database=myDB;'
    r'Trusted_Connection=yes;'
    )
cnxn = pyodbc.connect(conn_str)

(Note that there are no commas between the individual string components.)

More Related Contents:

  1. Create a view with ORDER BY clause
  2. How to run the same query on all the databases on an instance?
  3. SQL Update with row_number()
  4. How to write UTF-8 characters using bulk insert in SQL Server?
  5. Is a single SQL Server statement atomic and consistent?
  6. determining the character set of a table / database?
  7. How to query for Xml values and attributes from table in SQL Server?
  8. A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)
  9. Should every User Table have a Clustered Index?
  10. cross apply xml query performs exponentially worse as xml document grows
  11. Intermittent ODBC connection failures
  12. SQL Server Configuration Manager cannot be found
  13. Getting a warning when using a pyodbc Connection object with pandas
  14. Compute MD5 hash of a UTF8 string
  15. Sql Server replication requires the actual server name to make a connection to the server
  16. Convert a string with ‘YYYYMMDDHHMMSS’ format to datetime
  17. Convert from DateTime to INT
  18. Cross Domain SQL Server Logins Using Windows Authentication
  19. Python – pyodbc call stored procedure with parameter name
  20. replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
  21. SQL Server 2008 Spatial: find a point in polygon
  22. Pyodbc: Login Timeout Error
  23. Storing images in SQL Server?
  24. Limitations of SQL Server Express
  25. SQL time difference between two dates result in hh:mm:ss
  26. How to determine total number of open/active connections in ms sql server 2005
  27. “Prevent saving changes that require the table to be re-created” negative effects
  28. freeTDS not using its config
  29. @@ERROR and/or TRY – CATCH
  30. How to make a passthrough / passthru query editable?

Leave a Comment