Improved Python Connectivity with SQL Server Using Cross-platform Pyodbc

Pyodbc (Python-SQL Server Connector), an open source Python module uses ODBC Drivers to connect to SQL Server.

Share online:

Python is one of the most popular and fastest-growing programming languages used today, developers can learn about updates that improve Python connectivity with SQL Server —among them Pyodbc (Python-SQL Server Connector) is officially supported.

If you are not aware, "Pyodbc is an open source crosss platform Python module that allows you to connect from the platform of your choice to SQL Server on-premises and in the cloud." It can be installted using pip.

Microsoft also recently announced SQL Server v.Next CTP1, which brings the power of SQL Server to both Windows and on Linux. You can now connect applications to SQL Server running on Linux, Windows and macOS "with Docker."

The following updates are available for Python developers: "You can contact Microsoft Customer Service and Support (CSS) via phone, email, Twitter, forums, etc., to report and get help with any issue," "Compatible with Python 3.5 and Django 1.10 through Django-pyodbc-azure," and "Available in Jupyter Notebooks for SQL Server: The Jupyter Notebook is a web application that allows you to create and share documents that contain live code, equations and visualizations. Pyodbc and its dependencies ship out of the box with Juypter notebooks on Azure."

To get started, follow these tutorials that show you how to:

  • Install SQL Server on Linux or Windows or run on Docker in multiple platforms.
  • Create a simple app using C#, Java, Node.js, PHP and Python with SQL Server.
  • Create a simple app using popular web frameworks like Django with SQL Server.
  • Try out some cool SQL Server features that can make your apps shine.
  • Get the latest v17.0 RC1 versions of SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT).
  • Get mssql extension for Visual Studio Code and develop apps with SQL Server on Linux/macOS/Windows, see more here.

About The Author

Deepak Gupta is a IT & Web Consultant. He is the founder and CEO of diTii.com & DIT Technologies, where he’s engaged in providing Technology Consultancy, Design and Development of Desktop, Web and Mobile applications using various tools and softwares. Sign-up for the Email for daily updates. Google+ Profile.