Connecting to SQL Server 2012 using sqlalchemy and pyodbc

by

The file-based DSN string is being interpreted by SQLAlchemy as server name = c, database name = users.

I prefer connecting without using DSNs, it’s one less configuration task to deal with during code migrations.

This syntax works using Windows Authentication:

engine = sa.create_engine('mssql+pyodbc://server/database')

Or with SQL Authentication:

engine = sa.create_engine('mssql+pyodbc://user:password@server/database')

SQLAlchemy has a thorough explanation of the different connection string options here.

More Related Contents:

  1. pyodbc.connect() works, but not sqlalchemy.create_engine().connect()
  2. How to speed up bulk insert to MS SQL Server using pyodbc
  3. Speeding up pandas.DataFrame.to_sql with fast_executemany of pyODBC
  4. Error 28000: Login failed for user DOMAIN\\user with pyodbc
  5. stored procedures with sqlAlchemy
  6. Python call sql-server stored procedure with table valued parameter
  7. Writing a csv file into SQL Server database using python
  8. Using SQL Server stored procedures from Python (pyodbc)
  9. How to upsert pandas DataFrame to Microsoft SQL Server table?
  10. to_sql pyodbc count field incorrect or syntax error
  11. How do I connect to SQL Server via sqlalchemy using Windows Authentication?
  12. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  13. Remote connection to MS SQL – Error using pyodbc vs success using SQL Server Management Studio
  14. SQLAlchemy create_all() does not create tables
  15. python pip specify a library directory and an include directory
  16. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  17. SQL Alchemy ORM returning a single column, how to avoid common post processing
  18. How do I execute inserts and updates in an Alembic upgrade script?
  19. Get data from pandas into a SQL server with PYODBC
  20. SQLAlchemy, get object not bound to a Session
  21. Flask sqlalchemy many-to-many insert data
  22. How to delete a record by id in Flask-SQLAlchemy
  23. Connection problems with SQLAlchemy and multiple processes
  24. How to do an upsert with SqlAlchemy?
  25. SQLAlchemy printing raw SQL from create()
  26. SQLAlchemy: how to filter date field?
  27. method of iterating over sqlalchemy model’s defined columns?
  28. How to execute “left outer join” in SqlAlchemy
  29. Can’t change system default SQLite binary
  30. using sqlalchemy to load csv file into a database

Leave a Comment