DEV Community

loading...

Connecting to ODBC databases from Python with pyodbc

andreasneuman profile image andreasneuman ・1 min read

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)

pic
Editor guide