pymssql ¶ A simple database interface for Python that builds on top of FreeTDS to provide a Python DB-API (PEP-249) interface to Microsoft SQL Server. The 2.x branch of pymssql is …

pymssql ¶ A simple database interface for Python that builds on top of FreeTDS to provide a Python DB-API (PEP-249) interface to Microsoft SQL Server. The 2.x branch of pymssql is …

The document set you are reading describes exclusively the code base of pymssql 2.x and newer. All description of functionality, workarounds, limitations, dependencies, etc. of older revisions …

You can use the pymssql.set_wait_callback() function to install a callback function you should write yourself. This callback can yield to another greenlet, coroutine, etc.

pymssql module reference ¶ Complete documentation of pymssql module classes, methods and properties.

pymssql module reference ¶ Complete documentation of pymssql module classes, methods and properties.

Please note the usage of iterators and ability to access results by column name. Also please note that parameters to connect method have different names than in pymssql module.

Calling stored procedures ¶ As of pymssql 2.0.0 stored procedures can be called using the rpc interface of db-lib.

There is a known issue where some versions of pymssql 1.x (pymssql 1.0.2 is where I’ve seen this) work well with FreeTDS 0.82, but return no rows when used with newer versions of …

Starting with pymssql version 2.0.0 and up to version 2.1.2 it was already possible to set the TDS protocol version to ask for when connecting to the server but version 7.1 was used if not …