Tutorial: Connecting to ODBC Data Sources with Python and pyodbc

Tutorial: Connecting to ODBC Data Sources with Python and pyodbc

August 10, 2017 0 Comments
Tutorial Connecting to ODBC Data Sources with Python and pyodbc_870x220

In this tutorial, learn how to install and use a DataDirect ODBC driver, Python and pyodbc. Code samples are included.

Python is a general-purpose interpreted, interactive, object-oriented, and high-level programming language. It was created by Guido van Rossum and first released in 1991.

Pyodbc is an open source Python module that makes accessing ODBC databases simple. It implements the DB API 2.0 specification. Using pyodbc, you can easily connect Python applications to data sources with an ODBC driver.


python

As with other application stacks connecting through the ODBC API, the application—in this case your python code along with the pyodbc module—will use an ODBC driver manager and ODBC driver. The ODBC driver manager is platform-specific, while the ODBC driver is database-specific. The ODBC driver manager and driver will connect, typically over a network, to the database server.

For more information on pyodbc, see the Github Pyodbc Wiki

Once a connection has been established, your application can execute selects, inserts, or other ODBC operations supported by your driver and database.

PythonODBCTerminal3

We've written a tutorial to show you how to install a DataDirect ODBC driver, Python and pyodbc. We've also provided a code sample demonstrating a connection to Microsoft SQL Server using the Python ODBC interface via the Progress DataDirect Connect64 for ODBC SQL Server Wire Protocol driver.

While this tutorial uses a simple code sample to connect and demonstrate basic operations, we recommend that you fully test your ODBC driver with the complete set of operations you expect to use in your production application. A quick test connection can demonstrate that connectivity has been successfully established, but won't necessarily test all the operations and load used by a full application.

Our tutorial demonstrates a connection to SQL Server with pyodbc, but you can use the same steps to connect to any data source using a DataDirect ODBC driver. Instead of using a data source, the code can also be modified to pass a connection string to the pyodbc.connect() function for DSN-less connections.

Get Started Today

Download a free 15 day trial of DataDirect ODBC drivers. Then follow our tutorial to connect to your database using Python and pyodbc.

Start the Tutorial


Saikrishna-Teja-Bobba_164x164.jpg

Saikrishna Teja Bobba

Saikrishna is a DataDirect Developer Evangelist at Progress. Prior to working at Progress, he worked as Software Engineer for 3 years after getting his undergraduate degree, and recently graduated from NC State University with Masters in Computer Science. His interests are in the areas of Data Connectivity, SaaS and Mobile App Development.

Read next Tutorial: Using Jaspersoft Studio to Access Data Behind a Firewall
Comments
Comments are disabled in preview mode.