DEV Community


Posted on

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

Top comments (0)