pymssql #######

Building

To build pymssql you should have:

• python >= 2.5 including development files. Please research your OS usual software distribution channels, e.g, python-dev or python-devel packages)
• Cython >= 0.15
• FreeTDS >= 0.91 including development files. Please research your OS usual software distribution channels, e.g, freetds-dev or freetds-devel packages)

Windows

MinGW ^^^^^

Add to the above requirements:

• MinGW

then you can run::

python setup.py build -c mingw32

which will build pymssql in the normal python fashion.

MS Visual C++ ^^^^^^^^^^^^^

Environment Setup:

The commands below should be ran inside a Visual Studio command prompt or a
command prompt window where the ``vcsvars*.bat`` file has been previously run so
it can set the needed environment vars.

Building FreeTDS:

Build FreeTDS from the current or stable tarball.

.. _current: http://ibiblio.org/pub/Linux/ALPHA/freetds/current/ .. _stable: http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/

Use nmake (included with VS C++) to build FreeTDS. To do that,

Define in the environment or on the command line:

1. CONFIGURATION = debug/release
2. PLATFORM = win32/x64

These will determine what is built and where outputs are placed.

Example invocations::

nmake.exe -f Nmakefile -nologo PLATFORM=win32 CONFIGURATION=debug nmake.exe -f Nmakefile -nologo build-win32d

Fixing build errors: I ran into a couple build errors when using VS 2008, see the following links for resolutions:

• http://www.freetds.org/userguide/osissues.htm
• http://lists.ibiblio.org/pipermail/freetds/2010q4/026343.html

When this is done, the following files should be available (depending on CONFIGURATION and PLATFORM used above)::

src\dblib\\\db-lib.lib src\tds\\\tds.lib

for example::

src\dblib\win32\release\db-lib.lib src\dblib\win32\release\tds.lib

Those files should then be copied to::