pymssql Introduction

A simple database interface to Microsoft SQL Server (MS-SQL) for Python that builds on top of FreeTDS to provide a Python DB-API (PEP-249) interface to SQL Server.

The 2.x branch of pymssql is built on the latest release of FreeTDS which removes many of the limitations found with older FreeTDS versions and the 1.x branch.

Resources

• Docs & Project Home
  • Quick Start: coming soon :)
  • FAQ & Troubleshooting
• PYPI Project
• GitHub
• Discussion
• FreeTDS User Guide

Features

• Unicode friendly
• Python 3 friendly
• Works on most popular operating systems
• Written in Cython for performance
• Includes a supported and documented low-level module (_mssql) that you can use instead of the DB-API
• Supports stored procedures with both return values and output parameters
• A comprehensive test suite

License

pymssql is licensed under the terms of the GNU LGPL license.

Survey

Can you take a minute and fill out this survey to help us prioritize development tasks?

https://www.surveymonkey.com/s/KMQ8BM5

Recent Changes

<Need to import>

Documentation

• Introduction
  • Architecture
  • Project Discussion
  • Project Status
  • Current Development
• pymssql examples
  • Basic features (strict DB-API compliance)
  • Iterating through results
  • Rows as dictionaries
  • Using the with statement (context managers)
  • Calling stored procedures
• _mssql examples
  • Quickstart usage of various features
  • An example of exception handling
• Release notes
  • pymssql 2.0.0
• FreeTDS configuration
  • Testing the connection
• pymssql module reference
  • Module-level symbols
  • Functions
  • Connection class
  • Cursor class
• _mssql module reference
  • Module-level symbols
  • Functions
  • MSSQLConnection class
  • MSSQLStoredProcedure class
  • Module-level exceptions
• Migrating from 1.x to 2.x
  • str vs. unicode
  • Handling of uniqueidentifier columns
  • Arguments to pymssql.connect
  • Parameter substitution
• Frequently asked questions
  • Cannot connect to SQL Server
  • Returned dates are not correct
  • Queries return no rows
  • Results are missing columns
  • pymssql does not unserialize DATE and TIME columns to datetime.date and datetime.time instances
  • Shared object “libsybdb.so.3” not found
  • “DB-Lib error message 20004, severity 9: Read from SQL server failed” error appears
  • More troubleshooting
• Building and developing pymssql
  • Building
  • Testing
• FreeTDS and dates
  • Summary
  • Details
• To-do list
  • Complete
  • Partially Complete
  • Incomplete
  • Documentation
• Change log
• Project history
  • The beginning
  • Important releases
  • License change
  • LGPLed releases

Indices and tables

• Index
• Module Index
• Search Page