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

pymssql examples. Basic features (strict DB-API compliance) Connecting using Windows Authentication; Iterating through results; Important note about Cursors; Rows as dictionaries; …

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 …

pymssql examples. Basic features (strict DB-API compliance) Iterating through results; Rows as dictionaries; Using the with statement (context managers) Calling stored procedures; _mssql …

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.

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 …

See the pymssql examples document for a more concrete example. A pymssql extension to the DB-API 2.0.

pymssql uses FreeTDS package to connect to SQL Server instances. You have to tell it how to find your database servers. The most basic info is host name, port number, and protocol …

Starting with version 2.1.1 pymssql can be used to connect to Microsoft Azure SQL Database. Make sure the following requirements are met: Use FreeTDS 0.91 or newer; Use TDS protocol …