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.

Download

Latest version is pymssql 1.0.2 released 2009-04-28.

Download from Sourceforge.net

Runtime Requirements

In order to run pymssql, you need the following:

  • Python language. Please check Platforms page for version info.
  • Linux, *nix and Mac OS X: FreeTDS 0.63 or newer. Your OS may have a package for that, example names are libfreetds0, lib64freetds0, freetds0. On FreeBSD there is a port databases/freetds-msdblib.
    NOTE: FreeTDS must be configured with --enable-msdblib to return correct dates! FreeTDS and Dates document for details.
  • NOTE: pymssql doesn't invalidate the requirement for an SQL Client Access Licence for every host you want to run it on, be it Windows or *nix, if your SQL Server is licenced per user or per device connected.

More info: pymssql on Windows is equipped with ntwdblib.dll library version 2000.80.2187.0 which is distributed by Microsoft in SQL 2000 SP4 package. This is not the newest available version, but there was a problem with newest version 2000.80.2273.0. This library is redistributable -- see REDIST.txt on the SQL Server 2000 installation media, in SQL Server 2000 SP4 installation package, or here (it is copied here just to have a reference of these rights). You don't have to install full MS SQL Client Tools package unless you need to use advanced client configuration tools available there, for example Client Network Utility.



Compilation and installation from source

If you need to compile pymssql from source, please see Compilation.