cTDS

cTDS is a full Python DB API-2.0-compliant SQL Server database library for Linux, Windows, and Mac OS X supporting both Python 2 and Python 3.

The full documentation for cTDS can be found here.

Features

• Supports Microsoft SQL Server 2008 and up.

• Complete DB API-2.0 support.

• Python 2.6, Python 2.7, Python 3.3, Python 3.4, Python 3.5, Python 3.6, Python 3.7, Python 3.8, and Python 3.9 support.

• Bulk insert (bcp) support.

• Written entirely in C.

Dependencies

• FreeTDS

• Python

Index

• Index

• Module Index

• Search Page

Table of Contents

• Getting Started
  • Installing FreeTDS
  • PIP Installation
• Basic Example
• Executing SQL
  • Passing Parameters
  • Limitations
• Calling Stored Procedures
  • Passing tuple parameters
  • Passing dict parameters
  • Output Parameters
• Reading Results
  • Fetching Rows
  • Advancing the Result Set
• Transactions
  • Autocommit
• Bulk Insert
  • Example
  • Inserting from a CSV File
  • Batch Size
  • Text Columns
• Connection Pooling
  • ctds.pool Example
  • antipool Example
• Frequently Asked Questions
  • Why can’t I pass an empty string to ctds.Cursor.callproc()?
  • Why don’t str values map to (N)VARCHAR in Python 2?
  • Why doesn’t RAISERROR raise a Python exception?
  • What does the Unicode codepoint U+1F4A9 is not representable… warning mean?
• API Reference
  • Connection
  • Cursor
  • ctds
  • Parameter
  • RowList
  • SQL Type Wrappers
  • ctds.pool
• Change Log
  • Unreleased
  • 1.14.0 - 2021-03-25
  • 1.13.0 - 2020-11-12
  • 1.12.0 - 2020-03-07
  • 1.11.0 - 2019-11-14
  • 1.10.1 - 2019-06-27
  • 1.10.0 - 2019-04-15
  • 1.9.0 - 2018-11-05
  • 1.8.0 - 2018-09-07
  • 1.7.0 - 2018-01-24
  • 1.6.3 - 2017-12-05
  • 1.6.2 - 2017-11-27
  • 1.6.1 - 2017-11-20
  • 1.6.0 - 2017-11-17
  • 1.5.0 - 2017-10-16
  • 1.4.1 - 2017-09-29
  • 1.4.0 - 2017-09-13
  • 1.3.2 - 2017-07-25
  • 1.3.1 - 2017-05-31
  • 1.3.0 - 2017-03-15
  • 1.2.3 - 2017-03-13
  • 1.2.2 - 2017-01-10
  • 1.2.1 - 2016-12-27
  • 1.2.0 - 2016-12-27
  • 1.1.0 - 2016-11-14
  • 1.0.8 - 2016-08-17
  • 1.0.7 - 2016-08-15
  • 1.0.6 - 2016-08-15
  • 1.0.5 - 2016-05-23
  • 1.0.4 - 2016-05-19
  • 1.0.3 - 2016-03-31
  • 1.0.2 - 2016-03-15
  • 1.0.1 - 2016-03-14
  • 1.0.0 - 2016-03-14