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/