Python Connector for SQL Server
Python Connector for SQL Server icon

Python Connector for SQL Server

by Devart
$74.95
Python Connector for SQL Server boxshot
Version
1.4.0
License
Shareware
Trial Limitations
30-day free trial, evaluation use only, not for production
Operating Systems
Windows 32-bit and 64-bit, Windows Server, macOS 64-bit and ARM (Apple silicon), Linux 64-bit
System Requirements
Python 3.10 to 3.15. Windows 32/64-bit, Windows Server, macOS 64-bit and Apple silicon, Linux 64-bit. SQL Server 2000 to 2025, including Express. No SQL Server client library needed
File Size
4.27 MB
Release Date
10/22/2026
Last Updated
11/17/2026
14 views 0 downloads
DB API 2.0 Python connector for Microsoft SQL Server, no client library needed

Devart Python Connector for SQL Server: SQL Server Access from Python Without an ODBC Driver

Devart Python Connector for SQL Server is a paid Python database module, $74.95 a year for one developer, that connects Python 3.10-3.15 code on Windows, macOS and Linux directly to Microsoft SQL Server 2000 through 2025, Express editions included. It follows the Python DB API 2.0 standard, installs with pip, and talks to the server itself, so there's no ODBC driver or SQL Server client to install.

The usual way to reach SQL Server from Python is pyodbc plus Microsoft's ODBC driver, which means installing and matching a system driver on every machine and container that runs your code. Devart's connector replaces that pair with one pip package, and adds SSH and HTTP tunneling, Windows authentication and Always Encrypted support on top.

Quick facts

  • Version: 1.4.0, released October 22, 2026; first released December 1, 2023
  • Developer: Devart
  • Package: pip install devart-sqlserver-connector, or wheel files from Devart's download page (4.27 MB for Windows, 6.51 MB for macOS, 4.30 MB for Linux)
  • Python: 3.10 to 3.15 (1.4 dropped 3.7 to 3.9)
  • Servers: SQL Server 2000 (including MSDE) through SQL Server 2025, Express editions included
  • Sign-in: SQL Server (mixed mode) or Windows authentication
  • Platforms: Windows 32-bit and 64-bit (and Windows Server), macOS Intel and Apple silicon, Linux 64-bit
  • Price: $74.95 a year or $149.95 perpetual for a Single (one developer) license
  • Trial: 30 days, for evaluation only, not for production use
  • Refund: the order page promises a 30-day money-back guarantee "if you are not satisfied", while Devart's ordering FAQ grants refunds within 30 days only when a technical problem support can't fix stops the product working
  • What we checked: the order page charged $74.95 for a Single license with one year of updates on a yearly subscription ($149.95 perpetual, $189.95 a year for Team, $339.95 for Site), and PyPI and Devart's download page both showed version 1.4.0 with wheels for Python 3.10 to 3.15, on November 17, 2026. We didn't run it against a SQL Server instance

Download Free Trial Buy Now

Overview

Code looks like any DB API module: import devart.sqlserver, then devart.sqlserver.connect(Server=..., Database=..., UserId=..., Password=...), or Authentication="Windows" to sign in with your Windows account instead of a SQL login. You get a cursor, execute() with ? placeholders, and the usual fetchone()/fetchall() calls. The port defaults to 1433.

Because the connector speaks SQL Server's network protocol itself, the same code runs on a Windows desktop, a Mac and a Linux server with nothing else installed. A license is activated in code with devart.sqlserver.license.activate("<key>").

Features

No ODBC driver to deploy

Devart Python Connector for SQL Server connects over TCP/IP without the SQL Server client libraries or an ODBC driver, so deploying a script to many workstations or containers is just a pip install. It ships as compiled wheels for 32-bit and 64-bit Windows, macOS (Intel and Apple silicon) and 64-bit Linux.

SQL Server 2000 to 2025

Devart Python Connector for SQL Server covers every SQL Server release from 2000 (and MSDE) to 2025, including the free Express editions. Version 1.3 improved compatibility with SQL Server 2000, and version 1.4 added SQL Server 2025 and Always Encrypted, so columns encrypted on the client side can be read and written from Python.

Tunnels and encryption

Devart Python Connector for SQL Server can connect over SSL/TLS, through an SSH tunnel, or through an HTTP/HTTPS tunnel, with bearer-token authentication for the HTTP tunnel since version 1.3. That lets a script reach a server behind a firewall or jump host without a separate tunnelling tool.

Pools, batches and types

Devart Python Connector for SQL Server pools connections when connection_pool.enabled is set, with min and max size, lifetime and validation settings and numbered pools chosen by PoolId. It can send several update statements as one batch, maps SQL Server types to Python types with options to change the mapping, and is Unicode-compliant.

Benefits

  • Simpler deployment. One pip package instead of pyodbc plus a system ODBC driver on every machine and Docker image.
  • Same code on every OS. Windows, macOS and Linux builds behave the same, with no driver-name differences in the connection string.
  • Legacy servers covered. Scripts can still read from SQL Server 2000 or 2005 boxes that newer drivers have dropped.
  • A vendor behind it. Paid support and yearly releases that follow new Python and SQL Server versions.

Real-World Uses

  • ETL from an old ERP database. A Python job pulls data from a SQL Server 2005 instance and loads it into a newer warehouse.
  • Reports through a jump host. An analyst's script reaches a production server that only allows SSH.
  • Windows sign-on. Internal tools on Windows workstations connect with the user's domain account instead of stored passwords.
  • Encrypted columns. An app reads Always Encrypted columns such as national ID numbers from Python.

Who It's For, and Who Should Skip It

The connector suits Python developers and data teams who are tired of installing and matching ODBC drivers across machines, who need tunnelled connections or very old SQL Server versions, or whose company wants a commercially supported component.

Skip it for hobby or open-source projects: the license forbids building Python packages on it for public distribution or sale, and pyodbc with Microsoft's free ODBC driver, or pymssql, already handles ordinary connections at no cost. It also needs Python 3.10 or newer, and it's a synchronous DB API driver with no asyncio interface.

Usage Guide

  1. Install with pip install devart-sqlserver-connector, or download the zip of wheels for your Python version and platform and run pip on the .whl file.
  2. After buying, copy the activation key from the order email or Devart's customer portal and run devart.sqlserver.license.activate("<key>") once.
  3. Connect with a SQL login: conn = devart.sqlserver.connect(Server="sql01", Database="Sales", UserId="report", Password="..."), or with Authentication="Windows" and no user or password.
  4. Query: cur = conn.cursor(), cur.execute("SELECT TOP 10 * FROM Orders WHERE CustomerID = ?", [42]), cur.fetchall().
  5. For a web app or service, turn on pooling with devart.sqlserver.connection_pool.enabled = True.

Before you buy

pyodbc code uses a DRIVER={...} connection string and ? placeholders, so queries usually carry over, but connection code and any driver-specific settings need rewriting. The subscription license checks its status online, so a server with no internet access needs the perpetual license.

Where it falls short

  • Not open source. You can't inspect or patch the code, and shipping it inside a product needs an OEM license.
  • Linux is 64-bit x86 only. There's no ARM Linux wheel, which rules out Graviton or Raspberry Pi servers.
  • Per-developer licensing. A Single license covers one user; a team of up to four needs the Team license.
  • Short documentation. The online docs cover connecting, pooling, tunnels and the API reference, but have few worked examples beyond basic queries.

Comparisons

Devart vs. pyodbc with Microsoft's ODBC driver

pyodbc and Microsoft ODBC Driver for SQL Server are free and widely used, and they're the default choice. Devart Python Connector for SQL Server costs $74.95 a year but needs no system driver, adds SSH and HTTP tunnelling, and supports servers back to SQL Server 2000. Choose it when driver installation or tunnelling is a real problem for you; otherwise the free pair is enough.

Python connector vs. Devart's ODBC driver for SQL Server

Devart's ODBC Driver for SQL Server ($179.95 a year for a desktop) serves Excel, Power BI, SSIS and any ODBC tool, plus Python through pyodbc. If Python is your only client, this $74.95 connector is the cheaper and lighter option; if reports and scripts both need SQL Server, the ODBC driver covers both.

Editions and Pricing

License1-year subscriptionPerpetualWho can use it
Single$74.95$149.95One developer at one company site
Team$189.95On the order pageUp to 4 developers at one company site
Site$339.95On the order pageUnlimited developers at one company site

Buy Now opens the order with a Single license on a 1-year subscription; Team, Site, the perpetual license and 2- or 3-year terms are chosen on the order page. An OEM license for distributing the connector with your own product is arranged with Devart separately.

FAQs

Does Devart Python Connector for SQL Server need the Microsoft ODBC driver?

No. Devart Python Connector for SQL Server connects directly over TCP/IP and doesn't use ODBC or the SQL Server client libraries, so nothing besides the pip package has to be installed.

Can I use Windows authentication from Python with it?

Yes. Devart Python Connector for SQL Server accepts Authentication=Windows, which signs in with the current Windows account; the default is SQL Server (mixed mode) authentication with a user ID and password.

Does it work with SQL Server 2025 and SQL Server Express?

Yes. Devart Python Connector for SQL Server 1.4 added SQL Server 2025, and its compatibility list includes the Express edition of every version from 2005 to 2025, plus SQL Server 2000 and MSDE.

Does Devart Python Connector for SQL Server support Python 3.9?

No. Version 1.4 supports Python 3.10 to 3.15 and removed 3.7, 3.8 and 3.9.

Does the subscription keep working offline?

No. Devart Python Connector for SQL Server's subscription license needs an internet connection to activate and check its status, and stops when the term ends. The perpetual license runs a specific version without a subscription.

Can I get a refund on Devart Python Connector for SQL Server?

Possibly. Devart Python Connector for SQL Server's order page offers a 30-day money-back guarantee if you're not satisfied, but Devart's ordering FAQ describes refunds within 30 days only for technical problems its support can't fix. Use the 30-day trial to be sure before you buy.

System Requirements

  • Python 3.10, 3.11, 3.12, 3.13, 3.14 or 3.15 with pip
  • Windows 32-bit or 64-bit, Windows Server, macOS (Intel or Apple silicon) or 64-bit Linux
  • SQL Server 2000 to 2025, including Express editions
  • Internet access for activating and checking a subscription license

Conclusion

Devart Python Connector for SQL Server is worth $74.95 a year if deploying ODBC drivers is a recurring headache, if you need SSH or HTTP tunnels built in, or if you still talk to SQL Server 2000-2008 machines. For a single app on a modern server where pyodbc and Microsoft's driver already work, it adds little, and the closed license rules it out for open-source work. Try it free for 30 days against your own server before deciding.

Download Free Trial Buy Now

Submit Your Review
Your Name:
Rating:
(Please click on one of the stars to indicate your rating.)
One Line Summary:
Review:
No html tags are allowed.
Submit Review
We may earn a commission when you buy through links on this page.
Copyright © 2026, Ivertech. All rights reserved.