DEV Community

andreasneuman
andreasneuman

Posted on

2 1

Connecting to ODBC databases from Python with pyodbc

Steps to connect to ODBC database in Python with pyodbc module

  1. Import the pyodbc module and create a connection to the database
  2. Execute an INSERT statement to test the connection to the database.
  3. Retrieve a result set from a query, iterate over it and print out all records.

Key Features

  • Direct mode
  • SQL data type mapping
  • Secure connection
  • ANSI SQL-92 standard support for cloud services

Learn more at https://www.devart.com/odbc/python/

Top comments (0)

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay