Projects / pymssql


The pymssql module provides access to MS SQL databases from Python scripts. It implements version 2.0 of the Python DB API.

Operating Systems

Recent releases

  •  28 Apr 2009 16:47

    Release Notes: All known issues are fixed in this release, and there are new features.

    •  05 Feb 2009 05:37

      Release Notes: This release fixes some bugs, including bug in the pymssql.execute() function introduced in 1.0.0, a charset bug, and some 64-bit issues. pymssql from now on includes the Nagios plugin.

      •  29 Jan 2009 21:59

        Release Notes: This released was almost rewritten from scratch, and addresses all requests received from users. There are many new features, improvements, bugfixes, and cleanups. There is also a new Web site, new docs, and examples.

        •  25 Sep 2006 00:06

          Release Notes: This is the first release under the LGPL. It's compatible with Python 2.5 and has a number of minor bugfixes.

          •  23 Feb 2006 06:00

            Release Notes: set_query_timeout() and set_login_timeout() were added. The min_error_severity property was added. stdmsg() is now deprecated, since all errors can be retrieved using errmsg(). ntwdblib.dll was added again. A new unit test was added. The Web page was improved. Bugfixes were made.

            Recent comments

            21 Jul 2007 06:31 aathan

            When using certain types of queries/stored procedures that use intermediate selects and one final select, it is possible to get multiple result sets even though only the last select is intended to return data. This is the case even though SQL Query Analyzer doesn't show the intermediate result. If you use connection.execute() followed by connection.fetchall() then you will be fetching one of the intermediate empty result sets and it will appear that pymssql is not working correctly. To fix this, use nextset() to get to the last result set before fetchall(). Or, add this lastset() function:

            def lastset(self):

            if self._result == None:

            return 0

            self.__resultpos = len(self._result) - 1

            return 1


            Project Spotlight


            A Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.