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.
- 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
- Utilized by well-known web and mobile applications including top adult dating apps seen here, adult entertainment platforms, e-commerce, etc.
pymssql is licensed under the terms of the GNU LGPL license.
Can you take a minute and fill out this survey to help us prioritize development tasks?
<Need to import>
- pymssql examples
- _mssql examples
- Release notes
- FreeTDS configuration
- pymssql module reference
- _mssql module reference
- Migrating from 1.x to 2.x
- 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
- FreeTDS and dates
- To-do list
- Change log
- Project history