JezK
Edit File: Python.html
<?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>Python</title><link rel="stylesheet" type="text/css" href="userguide.css" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="home" href="index.html" title="FreeTDS User Guide" /><link rel="up" href="software.html" title="Chapter 7. How to get what works with it working" /><link rel="prev" href="php.html" title="PHP" /><link rel="next" href="qt.html" title="Qt" /></head><body><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Python</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="php.html">Prev</a> </td><th width="60%" align="center">Chapter 7. How to get what works with it working</th><td width="20%" align="right"> <a accesskey="n" href="qt.html">Next</a></td></tr></table><hr /></div><div class="sect1"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="Python"></a>Python</h2></div></div></div><div class="sect2"><div class="titlepage"><div><div><h3 class="title"><a id="pymssql"></a>pymssql</h3></div></div></div><p>The <span class="productname">pymssql</span> module is a simple database interface to Microsoft SQL Server for <span class="productname">Python</span> that builds on top of <span class="productname">FreeTDS</span> to provide a Python DB-API v2 (<a class="ulink" href="http://www.python.org/dev/peps/pep-0249/" target="_top">PEP-249</a>) interface to Microsoft SQL Server.</p><p>The 2.x branch of <span class="productname">pymssql</span> take advantage of recent releases (0.91 and newer) of <span class="productname">FreeTDS</span> and by doing that removes many of the limitations previously found with older <span class="productname">FreeTDS</span> versions and the 1.x branch.</p><p><span class="productname">pymssql</span> features include:</p><div class="itemizedlist"><ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>Unicode friendly</p></li><li class="listitem"><p>Python 3 friendly</p></li><li class="listitem"><p>Works on most popular operating systems</p></li><li class="listitem"><p>Written in <a class="ulink" href="http://cython.org/" target="_top">Cython</a> for performance</p></li><li class="listitem"><p>Includes a supported and documented low-level module (<code class="filename">_mssql</code>) that you can use instead of the DB-API</p></li><li class="listitem"><p>Supports stored procedures with both return values and output parameters</p></li><li class="listitem"><p>A comprehensive test suite</p></li></ul></div><p>Please refer to the <span class="productname">pymssql</span> <a class="ulink" href="http://pymssql.org" target="_top">home page</a> where you'll find complete documentation on how to obtain, install and use it.</p></div><div class="sect2"><div class="titlepage"><div><div><h3 class="title"><a id="Sybase.Python.Module"></a>Sybase module</h3></div></div></div><p>You can obtain the <span class="productname">Python</span> Sybase module <a class="ulink" href="http://object-craft.com.au/projects/sybase/download.html" target="_top">here</a>. This example uses version 0.37, the most current at the time of this writing, please adjust accordingly if using a different version. </p><pre class="screen"> <code class="prompt">$ </code><strong class="userinput"><code>tar xvfz sybase-0.37.tgz</code></strong> <code class="prompt">$ </code><strong class="userinput"><code>cd sybase-0.37</code></strong> <code class="prompt">$ </code><strong class="userinput"><code>export SYBASE=/usr/local/freetds</code></strong> <code class="prompt">$ </code><strong class="userinput"><code>export CFLAGS="-DHAVE_FREETDS"</code></strong> <code class="prompt">$ </code><strong class="userinput"><code>export LD_LIBRARY_PATH=/usr/local/freetds/lib:${LD_LIBRARY_PATH}</code></strong> <code class="prompt">$ </code><strong class="userinput"><code>python setup.py install</code></strong></pre><p> Edit the example.py and fix the bottom stuff, <span class="productname">FreeTDS</span> lacks the 110 symbols for version use 100 </p><pre class="screen"> <code class="prompt">$ </code><strong class="userinput"><code>python example.py</code></strong></pre></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="php.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="software.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="qt.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">PHP </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> Qt</td></tr></table></div></body></html>