Skip to main content

New level of functionality and performance in data access via Python

Project description

Python Connector for SQL Server

Python Connector for SQL Server is a connectivity solution for accessing SQL Server databases from Python applications. It fully implements the Python DB API 2.0 specification. The connector is distributed as a wheel package for Windows, macOS, and Linux.

Direct connection

The connector enables you to establish a direct connection to SQL Server from a Python application via TCP/IP, eliminating the need for the database client library. A direct connection increases the speed of data transmission between the application and SQL Server database server. It also streamlines the deployment process since you don't have to distribute any client libraries with the application.

Secure communication

The connector supports encrypted communications using SSL/TLS, SSH tunneling, and HTTP/HTTPS tunneling.

Using the connector

To retrieve data from a database:

Import the module.

import devart.sqlserver

Connect to a database using the connect() module method and obtain a connection object: If you're using mixed mode authentication:

my_connection = devart.sqlserver.connect("[!ConnectionString]")

If you're using Windows authentication:

my_connection = devart.sqlserver.connect("Authentication=Windows;Server=your_server;Database=your_database")

Create a cursor object using the cursor() connection method.

my_cursor = my_connection.cursor()

Execute the SQL statement using the execute() cursor method.

my_cursor.execute("SELECT * FROM employees")

Retrieve the result set using one of the fetch*() cursor methods.

for row in my_cursor.fetchall(): 
    print(row)

Ordering and activating the license

You can purchase a license for the connector on the ordering page:
https://www.devart.com/python/sqlserver/ordering.html

To activate the license, follow the instructions in the documentation:
https://docs.devart.com/python/sqlserver/activate-a-license.htm

What's new

Python Connector for SQL Server 1.2

  • Added support for Python 3.13

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

devart_sqlserver_connector-1.2.0-cp313-cp313-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.13 Windows x86-64

devart_sqlserver_connector-1.2.0-cp313-cp313-win32.whl (977.1 kB view details)

Uploaded CPython 3.13 Windows x86

devart_sqlserver_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.13 manylinux: glibc 2.34+ x86-64

devart_sqlserver_connector-1.2.0-cp313-cp313-macosx_10_13_universal2.whl (4.7 MB view details)

Uploaded CPython 3.13 macOS 10.13+ universal2 (ARM64, x86-64)

devart_sqlserver_connector-1.2.0-cp312-cp312-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.12 Windows x86-64

devart_sqlserver_connector-1.2.0-cp312-cp312-win32.whl (977.1 kB view details)

Uploaded CPython 3.12 Windows x86

devart_sqlserver_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.12 manylinux: glibc 2.34+ x86-64

devart_sqlserver_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl (4.7 MB view details)

Uploaded CPython 3.12 macOS 10.9+ universal2 (ARM64, x86-64)

devart_sqlserver_connector-1.2.0-cp311-cp311-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.11 Windows x86-64

devart_sqlserver_connector-1.2.0-cp311-cp311-win32.whl (977.1 kB view details)

Uploaded CPython 3.11 Windows x86

devart_sqlserver_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.11 manylinux: glibc 2.34+ x86-64

devart_sqlserver_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl (4.7 MB view details)

Uploaded CPython 3.11 macOS 10.9+ universal2 (ARM64, x86-64)

devart_sqlserver_connector-1.2.0-cp310-cp310-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.10 Windows x86-64

devart_sqlserver_connector-1.2.0-cp310-cp310-win32.whl (977.0 kB view details)

Uploaded CPython 3.10 Windows x86

devart_sqlserver_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.10 manylinux: glibc 2.34+ x86-64

devart_sqlserver_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl (4.7 MB view details)

Uploaded CPython 3.10 macOS 10.9+ universal2 (ARM64, x86-64)

devart_sqlserver_connector-1.2.0-cp39-cp39-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.9 Windows x86-64

devart_sqlserver_connector-1.2.0-cp39-cp39-win32.whl (977.0 kB view details)

Uploaded CPython 3.9 Windows x86

devart_sqlserver_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.9 manylinux: glibc 2.34+ x86-64

devart_sqlserver_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl (4.7 MB view details)

Uploaded CPython 3.9 macOS 10.9+ universal2 (ARM64, x86-64)

devart_sqlserver_connector-1.2.0-cp38-cp38-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.8 Windows x86-64

devart_sqlserver_connector-1.2.0-cp38-cp38-win32.whl (976.9 kB view details)

Uploaded CPython 3.8 Windows x86

devart_sqlserver_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.8 manylinux: glibc 2.34+ x86-64

devart_sqlserver_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl (4.7 MB view details)

Uploaded CPython 3.8 macOS 10.9+ universal2 (ARM64, x86-64)

devart_sqlserver_connector-1.2.0-cp37-cp37m-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.7m Windows x86-64

devart_sqlserver_connector-1.2.0-cp37-cp37m-win32.whl (976.9 kB view details)

Uploaded CPython 3.7m Windows x86

devart_sqlserver_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.7m manylinux: glibc 2.34+ x86-64

devart_sqlserver_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.7m macOS 10.9+ x86-64

File details

Details for the file devart_sqlserver_connector-1.2.0-cp313-cp313-win_amd64.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 2badfcbaf8ee6cac9d6e628a7f6102f3496b66b64901be14d57763528deb998b
MD5 dd399e696ba5285c4a1adcc7f44fb282
BLAKE2b-256 2a11617b9a5483853daf70ed101a8a70f49dc34082f2f7994bcbb5caa9be4b44

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp313-cp313-win32.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp313-cp313-win32.whl
Algorithm Hash digest
SHA256 fb8b14132383b565ea34e046af72d00776008422fdc19639d07f0e1affa54c2a
MD5 f9110070779ee0c42c4c927cb322a06f
BLAKE2b-256 6ec153977bcf34389b01195d7dca3d9119b671c4445063c27db802438264e5cb

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 52a501d8b4b1353adb19fc1e94e097051d652babd223a5e402e1426578bf52e4
MD5 056a1e9ec38d817f58da839c0f9d3c6a
BLAKE2b-256 2f9ac5eef442e45394e5af9a4754cf199514f631bb370f0793956bd16c0ca9b7

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp313-cp313-macosx_10_13_universal2.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp313-cp313-macosx_10_13_universal2.whl
Algorithm Hash digest
SHA256 711cb1c0330b2e0a28ca686cebcb5085e28e77c887a077e6de8dd0e4d9b67391
MD5 edf022a70eb944bafd481587711b5f8a
BLAKE2b-256 09a7df5d58721c0ec4eaa7dbf102152fe415d3a9a48a73ab2703dbd4da3ee3e4

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp312-cp312-win_amd64.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 d0467b7723f49f377806b6e34caaed111639051e478c558a7f92647db83d3e86
MD5 5f65c2d40b2c6336e9ca19cf7d140e80
BLAKE2b-256 5860c9ea58378188bec077a2f007a59908ce57c4c61ea52d3a91730d89b9d71c

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp312-cp312-win32.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp312-cp312-win32.whl
Algorithm Hash digest
SHA256 2f9149d2070c10e8ffb653e748f2aa8deb7f2b6e13c3237f041186ec5002eeb4
MD5 6de51070e05b144a78ffc06bb33d4b69
BLAKE2b-256 ef68efc2588180f798a12f4bad84cdd401c5eae16eefd29fe64369bea22a5711

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 368f007e9429eb64cb8651ac135149c88fe9e3038e0ae872abe5b6eb17ea46a6
MD5 c6e36f261f8c3c35def0fab18c011ca8
BLAKE2b-256 4c331289a6685d7a95cad7a28e10540121b2e23ce3b35534538a7f2dd6c85dbd

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 d4117aa83569b3bb2a3fb9649b8a6fca0906161ea605ea7caa4c3f4dfdb48a5d
MD5 2ae6d8fa30a3cc847e60d106672c3893
BLAKE2b-256 fd511427395dfc0c84a5210fc95ee77146c4ec80518e77b1804ea2d01a518b2a

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp311-cp311-win_amd64.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 4286809c8456a2def7549e32701769d549cb2a85e2e79a151625cc7a3bdfdac7
MD5 7c0393bd0f8916b33c6e09a38814dfc2
BLAKE2b-256 36ac16a35d53b3f757b0ad69874d5d8a335638afaa0ca4aa886356ba4a13b9fb

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp311-cp311-win32.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp311-cp311-win32.whl
Algorithm Hash digest
SHA256 7d2de3e87af9bb9a2a8ed5627ee3d47ae77a2ac6674c4e44696b3bbfb681d83a
MD5 cdac4e980d2af5770b0b069ea6807341
BLAKE2b-256 627507dbfbcb89ac7f8aaf1a61396ff26d62468b94eadb19edfe5a9c5e7b20c1

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 67d7dcc1eb5611dfbd428ee2956dd7fea46343eb2323de51363291eb8b49a644
MD5 652619f9eccdd86409670036a9222bcd
BLAKE2b-256 843259e89aa976745bb8489fb0f03ed48940724823270f9fd9b0083e2ae88237

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 6ce7d7641d96365828e470a2308c5f587ae7bb8b498493216ec1035d993e402e
MD5 5d4b4b6fd34aae9add9b62b905e4183a
BLAKE2b-256 832d08a3d83f6a3b55eabd815c3e2e92b6870fc5540860687d9968dfe4c8cea0

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp310-cp310-win_amd64.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 71ba7c15a3451169a9453f2726ba47c57355914a5ebe99bfb67ee1981028b760
MD5 446a0de062593399028ff4a9ac73d196
BLAKE2b-256 bdd575fc8678070f1ce6506848b1dc1eba2e7198902d940fdae06bec4be7a9ad

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp310-cp310-win32.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 f986072905b51d0dbe98b30e8eae36d063b5ada5a4f0da44ab9f4ca88bc5fde6
MD5 b43a21202c1123b3b5ecda6f9a8f7550
BLAKE2b-256 85fd0f6c94eb323fe9512cd34000fc69a77e27a0a09c3bce656907856365fd24

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 28c26729c6338e09e47591c3ef84ad5f73f62fe7f233d1ce9ca66bbb123c0240
MD5 f59ccb19d0451c205b76bed60ff8af09
BLAKE2b-256 9cdcdb80d38353a9f94c1c10e5e2a35cc02670095a4d2bdf220224d2cb9cfba1

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 71732d36a323002ade8abc918db045c2cd6fcb55e28aa4773415fe2a191d4689
MD5 b8c88e4499b17edf93e4aa2d2c650071
BLAKE2b-256 709417377e0791c8a0160c495bc8b60eb59e2be32d59a18f0d7379368e787614

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp39-cp39-win_amd64.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 a29954965d4b35038aedf466e2f47861e2d31cd0e0dad59625908925b3920c22
MD5 dd9a4c6697f69cf6451e8c4000011123
BLAKE2b-256 90952e3b65df6b021bc49b112f535b2799b88f090e63314b06d40ecf137a9c0a

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp39-cp39-win32.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 3da95ea1442a9dd36a9be13048127df9cf1d19024d82fcbde33d32d6991941b2
MD5 db1490396b34cbdbfc125002290218db
BLAKE2b-256 9a2871ac37109d7d6ea0e0d05329a2e631b7ed858dee29bffae9fb88c32c79d3

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 85e3970b5ce1acaf4def62d7634551a93d516bef0a08c9b6266bfd421a0216c8
MD5 ad45fa513d4055b30c1e35be7a47cf72
BLAKE2b-256 465cc78565286c73957ab2865aa03dd85579bd4b7f785464145af3b2d99bfca0

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 899bba48b9819c41aa987266bdef892a94e71c4d45d3858217abe87fe20a6cf1
MD5 8588d653b9dbe281a5618fef67d0d2be
BLAKE2b-256 01ac00de4a31089df01353abf2694584b913ed864bffbf1abff573c2636e393e

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp38-cp38-win_amd64.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 e7229000bf781e9bcc7fdd63e4edfd2029c80fba099dffeb9b2fd3d9bd1758ed
MD5 a4945e63031f5ace2940bc45dfcd4198
BLAKE2b-256 33cc24d2655bddc405e94a5f17c285fc2986117d2e6132ccc1cf9dc1b00ec3f1

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp38-cp38-win32.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 b68e6e107263681fad75f98beaa7d19072ccc4036582cf61d965c1e77b7bd2c1
MD5 89c32fb0f3d24492c922efe8583f5d4e
BLAKE2b-256 de6d1e2d1b5925fddd5c8cefd984607a4785e9bdb35cf9395086532d879de6dc

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 14a1cd9956927256cdf7f8dec832c849d1e58a792a851f2ab369f38d70296dcc
MD5 aab06daf35531444526d87a31df22194
BLAKE2b-256 5d36f3a62af8fb21061b42e2347d4a007d61bc93cfef362ba0053e9fedbb974a

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 79b4c93bd609a7e7767a5651df21787555827468054afe89b1db496a9462ec8c
MD5 7c45bb300d6c5c1de5a2a3734c6f9ce3
BLAKE2b-256 88f587b95de319ef7675adbcfe79a17c1b9f19303a1359b6cd58952601b8b96c

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp37-cp37m-win_amd64.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 d7509d0372f3431d5b1ebec4650ffe99f233dbda066f7661dcd1dce027254a48
MD5 e51b2144c073f19ad8b4249d7fe2e81e
BLAKE2b-256 73fa62beb482462bd6e3c76f6916482a9b66a2ac049838d9b5248bb347973e59

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp37-cp37m-win32.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 d7ef38203b095d2f13bd3bfbc5683a285ad52eaceb0c50001a71002e5b69cbb9
MD5 4718f3be9858ef6d235ca813e9906af3
BLAKE2b-256 c1d5fc4d52f169ef779be6b3efdd8d4431c9a86bd736db540d4fead1d68ae9b8

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 037d917aa572e5c057aa51897afeefdcf454361f15f7e88be34bd25ec5757052
MD5 686eaf9e239d41ea15ec1ba5f19f2ed0
BLAKE2b-256 319f707774f96ac5adf7ebc146585f9909d84cb4be63c890fb0b3adffbe4ef17

See more details on using hashes here.

File details

Details for the file devart_sqlserver_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlserver_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm Hash digest
SHA256 76840e5d55e4f525cc9f02e4806d508d2bffb6ad8103830fe37f76a26d19b393
MD5 92123fdb844c457d758b46400a7d708d
BLAKE2b-256 cc4c9a16d44b441ed3f482facec1d28e6c6d5e9662d8cb6b7ec23f76f2658699

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page