Connecting to ODBC databases from Python with pyodbc

github logo ・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/

twitter logo DISCUSS
Classic DEV Post from Nov 13 '19

Apples announces new 16-inch Macbook Pro

Discussion thread for the new Macbook Pro thread

andreasneuman profile image

Sore eyes?

dev.to now has dark mode.

Go to the "misc" section of your settings and select night theme ❀️