Projects / pymssql

pymssql

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

Tags
Licenses
Operating Systems
Implementation

RSS Recent releases

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.

  •  24 Sep 2006 17: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.

  •  22 Feb 2006 22: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.

RSS Recent comments

21 Jul 2007 06:31 aathan

lastset()
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

Screenshot

Project Spotlight

FísicaLab

An educational application for solving physics problems.

Screenshot

Project Spotlight

Teddy Templating Engine

An easy-to-read, HTML-based, mostly logic-less DOM templating engine.