Getting a warning when using a pyodbc Connection object with pandas

by

Is pyodbc becoming deprecated?

No. For at least the last couple of years pandas’ documentation has clearly stated that it wants either a SQLAlchemy Connectable (i.e., an Engine or Connection object) or a SQLite DBAPI connection. (The switch-over to SQLAlchemy was almost universal, but they continued supporting SQLite connections for backwards compatibility.) People have been passing other DBAPI connections (like pyodbc Connection objects) for read operations and pandas hasn’t complained … until now.

Is there a better way to achieve similar results without warning?

Yes. You can take your existing ODBC connection string and use it to create a SQLAlchemy Engine object as described in the SQLAlchemy 1.4 documentation:

from sqlalchemy.engine import URL
connection_string = "DRIVER={ODBC Driver 17 for SQL Server};SERVER=dagger;DATABASE=test;UID=user;PWD=password"
connection_url = URL.create("mssql+pyodbc", query={"odbc_connect": connection_string})

from sqlalchemy import create_engine
engine = create_engine(connection_url)

Then pass engine to the pandas methods you need to use.

More Related Contents:

  1. Pyodbc: Login Timeout Error
  2. Connecting to MS SQL Server with Windows Authentication using Python?
  3. to_sql pyodbc count field incorrect or syntax error
  4. Python – pyodbc call stored procedure with parameter name
  5. pyodbc.connect() works, but not sqlalchemy.create_engine().connect()
  6. SQL Server – error when creating stored procedure
  7. SQL Server insert if not exists best practice [closed]
  8. Are GUID collisions possible?
  9. SQL Server Escape an Underscore
  10. Does a foreign key automatically create an index?
  11. best way to convert and validate a date string
  12. Why use the INCLUDE clause when creating an index?
  13. LIKE vs CONTAINS on SQL Server
  14. How do I enable MSDTC on SQL Server?
  15. TSQL Try / Catch within Transaction or vice versa?
  16. Is there any difference between DECIMAL and NUMERIC in SQL Server?
  17. How can I see the formulas of an excel spreadsheet in pandas / python?
  18. SQL Server history table – populate through SP or Trigger?
  19. TSQL: Create a view that accesses multiple databases
  20. cross apply xml query performs exponentially worse as xml document grows
  21. What is the sql connection string I need to use to access localhost\SQLEXPRESS with Windows Authentication or SQL Authentication?
  22. Showing all index values when using multiIndexing in Pandas
  23. Grant Select on a view not base table when base table is in a different database
  24. migrate data from MS SQL to PostgreSQL?
  25. How to change column datatype in SQL Server database without losing data?
  26. Convert UTC Milliseconds to DATETIME in SQL server
  27. reading multiple files contained in a zip file with pandas
  28. To run a SSIS package outside of SQL Server Data Tools you must install Move File to Archive of Integration Services or higher
  29. Tool for Scripting Table Data
  30. pandas scatter plotting datetime

Leave a Comment