DEV Community

andreasneuman
andreasneuman

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 https://www.devart.com/odbc/python/

Discussion (0)