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)

AWS Security LIVE!

Tune in for AWS Security LIVE!

Join AWS Security LIVE! for expert insights and actionable tips to protect your organization and keep security teams prepared.

Learn More

👋 Kindness is contagious

Discover a treasure trove of wisdom within this insightful piece, highly respected in the nurturing DEV Community enviroment. Developers, whether novice or expert, are encouraged to participate and add to our shared knowledge basin.

A simple "thank you" can illuminate someone's day. Express your appreciation in the comments section!

On DEV, sharing ideas smoothens our journey and strengthens our community ties. Learn something useful? Offering a quick thanks to the author is deeply appreciated.

Okay