<div dir="ltr"><span style="font-family:arial,sans-serif;font-size:14px">PyPyODBC - A Pure Python ctypes ODBC module</span><br style="font-family:arial,sans-serif;font-size:14px"><br style="font-family:arial,sans-serif;font-size:14px">
<h2 style="font-size:large;background-image:none;border:0px;padding-left:0px;max-width:700px;color:rgb(0,0,0);font-family:arial,sans-serif">Features</h2><ul style="padding-left:25px;max-width:62em;color:rgb(0,0,0);font-family:arial,sans-serif;font-size:13px">
<li style="margin-bottom:0.3em"><strong>One pure Python script, runs on CPython / <a href="http://ironpython.codeplex.com/" rel="nofollow" style="color:rgb(0,0,204)">IronPython</a> / <a href="http://pypy.org/" rel="nofollow" style="color:rgb(0,0,204)">PyPy</a> , Version 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux , 32 / 64 bit</strong></li>
<li style="margin-bottom:0.3em"><strong>Almost totally same usage as <a href="http://code.google.com/p/pyodbc" rel="nofollow" style="color:rgb(0,0,204)">pyodbc</a></strong> ( can be seen as a re-implementation of pyodbc in pure Python )</li>
<li style="margin-bottom:0.3em"><strong>Simple - the whole module is implemented in a single python script with less than <a href="http://code.google.com/p/pypyodbc/source/browse/trunk/pypyodbc/pypyodbc.py" rel="nofollow" style="color:rgb(0,0,204)">3000 lines</a></strong></li>
<li style="margin-bottom:0.3em"><strong>Built-in Access MDB file creation and compression functions on Windows</strong></li></ul><p style="line-height:1.25em;max-width:64em;color:rgb(0,0,0);font-family:arial,sans-serif;font-size:13px">
Simply try pypyodbc:</p><pre class="" style="font-size:12px;padding:0.5em;overflow:auto;font-family:Monaco,'DejaVu Sans Mono','Bitstream Vera Sans Mono','Lucida Console',monospace;max-width:70em;background-color:rgb(238,238,238);color:rgb(0,0,0)">
<span class="" style="color:rgb(0,0,136)">import</span><span class=""> pypyodbc <br>             <br>pypyodbc</span><span class="" style="color:rgb(102,102,0)">.</span><span class="">win_create_mdb</span><span class="" style="color:rgb(102,102,0)">(</span><span class="" style="color:rgb(0,136,0)">'D:\\database.mdb'</span><span class="" style="color:rgb(102,102,0)">)</span><span class=""><br>
<br>connection </span><span class="" style="color:rgb(102,102,0)">=</span><span class=""> pypyodbc</span><span class="" style="color:rgb(102,102,0)">.</span><span class="">connect</span><span class="" style="color:rgb(102,102,0)">(</span><span class="" style="color:rgb(0,136,0)">'Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\database.mdb'</span><span class="" style="color:rgb(102,102,0)">)</span><span class=""><br>
<br>SQL </span><span class="" style="color:rgb(102,102,0)">=</span><span class=""> </span><span class="" style="color:rgb(0,136,0)">'CREATE TABLE saleout (id COUNTER PRIMARY KEY,product_name VARCHAR(25))'</span><span class=""><br>
<br>connection</span><span class="" style="color:rgb(102,102,0)">.</span><span class="">cursor</span><span class="" style="color:rgb(102,102,0)">().</span><span class="">execute</span><span class="" style="color:rgb(102,102,0)">(</span><span class="">SQL</span><span class="" style="color:rgb(102,102,0)">)</span><span class=""><br>
</span></pre><br><div><p style="line-height:1.5;color:rgb(0,0,0);font-family:Arial,Verdana,Geneva,'Bitstream Vera Sans',Helvetica,sans-serif;font-size:15px"><a class="" href="http://code.google.com/p/pypyodbc/" style="border-bottom-width:1px;border-bottom-style:dashed;border-bottom-color:rgb(204,204,204);color:rgb(85,26,139);text-decoration:initial">Home Page</a></p>
<p style="line-height:1.5;color:rgb(0,0,0);font-family:Arial,Verdana,Geneva,'Bitstream Vera Sans',Helvetica,sans-serif;font-size:15px"><a class="" href="http://blog.sina.com.cn/s/blog_6c64ac1501019ns8.html" style="border-bottom-width:1px;border-bottom-style:dashed;border-bottom-color:rgb(204,204,204);color:rgb(85,26,139);text-decoration:initial">Tutorial</a></p>
<p style="line-height:1.5;color:rgb(0,0,0);font-family:Arial,Verdana,Geneva,'Bitstream Vera Sans',Helvetica,sans-serif;font-size:15px"><a class="" href="http://blog.sina.com.cn/s/blog_6c64ac1501019mx2.html" style="border-bottom-width:1px;border-bottom-style:dashed;border-bottom-color:rgb(204,204,204);color:rgb(85,26,139);text-decoration:initial">教程</a></p>
<p style="line-height:1.5;color:rgb(0,0,0);font-family:Arial,Verdana,Geneva,'Bitstream Vera Sans',Helvetica,sans-serif;font-size:15px"><a class="" href="http://blog.sina.com.cn/s/blog_6c64ac1501019ost.html" style="border-bottom-width:1px;border-bottom-style:dashed;border-bottom-color:rgb(204,204,204);color:rgb(85,26,139);text-decoration:initial">Tutorial (Français)</a></p>
</div><div><br></div><div><br></div></div>