Carview!

CARVIEW

MOTORHOMES

Select Language

HTTP/2 302 server: nginx date: Mon, 22 Dec 2025 07:05:22 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20071213030540 location: https://web.archive.org/web/20071213030540/https://pymssql.sourceforge.net/ server-timing: captures_list;dur=2.702298, exclusion.robots;dur=0.070300, exclusion.robots.policy;dur=0.050520, esindex;dur=0.014577, cdx.remote;dur=21.120661, LoadShardBlock;dur=173.232455, PetaboxLoader3.datanode;dur=112.351555 x-app-server: wwwb-app219-dc8 x-ts: 302 x-tr: 275 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: wb-p-SERVER=wwwb-app219; path=/ x-location: All x-as: 14061 x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 200 server: nginx date: Mon, 22 Dec 2025 07:05:23 GMT content-type: text/html x-archive-orig-date: Thu, 13 Dec 2007 03:05:40 GMT x-archive-orig-server: Apache/1.3.33 (Unix) PHP/4.3.10 x-archive-orig-last-modified: Sun, 24 Sep 2006 10:35:01 GMT x-archive-orig-etag: "1e2c0d5-240f-45165f55" x-archive-orig-accept-ranges: bytes x-archive-orig-content-length: 9231 x-archive-orig-connection: close x-archive-guessed-content-type: text/html x-archive-guessed-charset: utf-8 memento-datetime: Thu, 13 Dec 2007 03:05:40 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: 51_1_20071212233120_crawl108-c/51_1_20071213025200_crawl106.arc.gz server-timing: captures_list;dur=0.453787, exclusion.robots;dur=0.013624, exclusion.robots.policy;dur=0.006823, esindex;dur=0.009419, cdx.remote;dur=9.494522, LoadShardBlock;dur=170.020880, PetaboxLoader3.datanode;dur=126.911791, PetaboxLoader3.resolve;dur=118.976964, load_resource;dur=125.319179 x-app-server: wwwb-app219-dc8 x-ts: 200 x-tr: 335 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-as: 14061 x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() content-encoding: gzip pymssql - Simple MSSQL Python extension module

pymssql - Simple MSSQL Python extension module

by 박준철

(Initial Version Developer, "박준철" is pronounced "Park joon-cheol")
Andrzej Kukuła

(Active Developer)

License change: due to demand from pymssql users author decided to change pymssql licence from GPL to LGPL.
pymssql 0.8.0 is the first version released under LGPL.

This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.

About pymssql
Supported Platforms
Supported SQL Server versions
Features
Download
Building
Example script - pymssql module (DB API 2.0)
Example script - _mssql module (lower level DB access)
FAQ / Troubleshooting
Links

About pymssql

This module provides access to Microsoft SQL Servers from Python scripts. It's the most efficient method of accessing MS SQL Server's data from Python scripts. If you care about performance, you can give it a try.

Supported Platforms

pymssql 0.8.0 has been tested on Linux with kernel 2.6, Windows XP, FreeBSD 6.1, and NetBSD 3.1. It should also run on other platforms. pymssql 0.8.0 has been tested with Python 2.4 and Python 2.5. Warning: previous versions will segfault when compiled and run with Python 2.5.

pymssql 0.7.4 has been tested (among others) on Mac OS X 10.4.7 (thanks Sébastien Arnaud).

pymssql 0.7.1 has been tested on FreeBSD 5.4 and 6.0, NetBSD 2.0.2, Linux with kernel 2.6, Solaris 10/x86, Mac OS X (thanks Joseph Kocherhans) and Windows XP. It should also run on other platforms.

If you have any experience with other platforms, just let me know and I'll add the info here.

Supported SQL Server versions

pymssql 0.8.0 on *BSD, Linux and Windows were successfully tested with:

SQL Server 2000 RTM, SP3a, SP4 and post-SP4 (versions 8.00.760, 2139, 2140, and 2187),
SQL Server 2005 Enterprise Edition RTM and SP1 (versions 9.00.1399.06 and 9.00.2047.00),
SQL Server 2005 Express Edition SP1 (version 9.00.2047.00).

Features

Supports connecting to Microsoft SQL 2000 and SQL 2005 servers, all editions and service pack levels (see also FAQ / Troubleshooting page).
Supports named instances and non-standard port numbers.
Great performance: it uses MS SQL DB-Library for C instead of Win32 ODBC.
Multiple Query/Multiple Result.
Supports "almost all" of the DB-API 2.0.

Python 2.4 or newer, 2.5 confirmed, but only with pymssql 0.8.0 or newer.
Linux, *nix and Mac OS X: FreeTDS 0.63 or newer.
NOTE: FreeTDS must be configured with --enable-msdblib to return correct dates! See README.freetds for details.
Windows: SQL Developer Tools, to be found on MS SQL 2000 installation media. You need to install MS SQL Client Tools with Developer Tools.

Windows: Microsoft Visual C++ .NET 2003 or Microsoft Visual Studio .NET 2003. These are usual Python 2.4 build requirements.

Runtime Requirements

Python 2.4 or newer (the code requires datetime module, and the API functions to manipulate datetime, that's why it won't run on Python earlier than 2.4, thanks Jakub Labath for pointing that out.)
Linux, *nix and Mac OS X: FreeTDS 0.63 or newer.
NOTE: FreeTDS must be configured with --enable-msdblib to return correct dates! See README.freetds for details.

Windows: pymssql is equipped with ntwdblib.dll version 2000.80.2087.0 distributed by MS in SQL 2000 post-SP4 hotfix - see KB916287, which supports connecting to MS SQL 2000 and 2005 servers. This library is redistributable -- see REDIST.txt in SQL Server 2000 installation package, or in SQL Server 2000 SP4 installation package.
You don't have to install full MS SQL Client Tools unless you want to use advanced client configuration tools available in that package.

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.