pymssql — simple MS SQL Python extension module
by 박준철 - Park joon-cheol - Park Joon-cheol (Initial Version Developer)
Andrzej Kukuła Andrzej Kukula (Old Developer)
Damien Churchill Damien Churchill (Active Developer)
pymssql is the Python language extension module that provides access to Microsoft SQL Servers from Python scripts.
It is compliant with Python DB-API 2.0 Specification.
pymssql project has moved to Google Code website at http://code.google.com/p/pymssql/. This page is not maintained and will not be updated anymore. Its contents is outdated and relevant to old versions. Latest stable release on this site is 1.0.2.

Tested platforms

This is the matrix of tested platforms and pymssql versions:

pymssql Python Operating system
<2.42.42.52.63.0 WindowsLinuxMacOSFreeBSDNetBSD Solaris
1.0.x - + + + - + 5 + 32/64-bit + 4 + 32/64 bit + 32/64 bit ND
0.8.0 *) - + + - - + + ND + + + 1
0.7.4 *) + + - - - + + + 2 + + + 1
0.7.1 *) + + - - - + + + 3 + + + 1
ND = no data -- not tested and not received any feedback.
*) pymssql 0.8.0 and earlier was only tested with 32-bit operating systems.
1 Solaris 10/x86.
2 thanks Sébastien Arnaud for reporting.
3 thanks Joseph Kocherhans for reporting.
4 thanks MunShik JEONG, and Kurt Sutter for reporting.
5 pymssql for Windows is available only for 32-bit Python. You can use it with 64-bit Windows. There is no native 64-bit pymssql, because Microsoft has not released 64-bit version of ntwdblib.dll library, to which pymssql could link.

If you have experience with other platforms, just let me know and I'll add the info here.

Tested SQL Server versions

pymssql was tested with the following servers:

  • SQL Server 2000 Standard and Enterprise Editions,
  • SQL Server 2000 Desktop Engine (MSDE 2000),
  • SQL Server 2005 Standard and Enterprise Editions,
  • SQL Server 2005 Express Edition,
  • SQL Server 2008 Express Edition.
All SQL Server service pack levels are fine.

Limitations and known issues


You may encounter some issues using this software. They are summarized on this page.