<div dir="ltr"><div><br></div><div style>PyPyODBC, the single script Python ODBC module, now runs under both Python 2.x and Python 3.3</div><div style><br></div><br><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<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="padding-left:0px;max-width:700px;font-size:large;font-family:arial,sans-serif;border:0px;background-image:none">Features</h2><ul style="padding-left:25px;max-width:62em;font-size:13px;font-family:arial,sans-serif">

<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)" target="_blank">IronPython</a> / <a href="http://pypy.org/" rel="nofollow" style="color:rgb(0,0,204)" target="_blank">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)" target="_blank">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)" target="_blank">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;font-size:13px;font-family:arial,sans-serif">
Simply try pypyodbc:</p><pre style="max-width:70em;overflow:auto;font-size:12px;background-color:rgb(238,238,238);font-family:Monaco,'DejaVu Sans Mono','Bitstream Vera Sans Mono','Lucida Console',monospace;padding:0.5em">
<span style="color:rgb(0,0,136)">import</span><span> pypyodbc <br>             <br>pypyodbc</span><span style="color:rgb(102,102,0)">.</span><span>win_create_mdb</span><span style="color:rgb(102,102,0)">(</span><span style="color:rgb(0,136,0)">'D:\\database.mdb'</span><span style="color:rgb(102,102,0)">)</span><span><br>

<br>connection </span><span style="color:rgb(102,102,0)">=</span><span> pypyodbc</span><span style="color:rgb(102,102,0)">.</span><span>connect</span><span style="color:rgb(102,102,0)">(</span><span style="color:rgb(0,136,0)">'Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\database.mdb'</span><span style="color:rgb(102,102,0)">)</span><span><br>

<br>SQL </span><span style="color:rgb(102,102,0)">=</span><span> </span><span style="color:rgb(0,136,0)">'CREATE TABLE saleout (id COUNTER PRIMARY KEY,product_name VARCHAR(25))'</span><span><br>
<br>connection</span><span style="color:rgb(102,102,0)">.</span><span>cursor</span><span style="color:rgb(102,102,0)">().</span><span>execute</span><span style="color:rgb(102,102,0)">(</span><span>SQL</span><span style="color:rgb(102,102,0)">)</span><span><br>

</span></pre><br><div><p style="line-height:1.5;font-size:15px;font-family:Arial,Verdana,Geneva,'Bitstream Vera Sans',Helvetica,sans-serif"><a 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" target="_blank">Home Page</a></p>

<p style="line-height:1.5;font-size:15px;font-family:Arial,Verdana,Geneva,'Bitstream Vera Sans',Helvetica,sans-serif"><a 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" target="_blank">Tutorial</a></p>

<p style="line-height:1.5;font-size:15px;font-family:Arial,Verdana,Geneva,'Bitstream Vera Sans',Helvetica,sans-serif"><a 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" target="_blank">教程</a></p>

<p style="line-height:1.5;font-size:15px;font-family:Arial,Verdana,Geneva,'Bitstream Vera Sans',Helvetica,sans-serif"><a 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" target="_blank">Tutorial (Français)</a></p>

</div><div><br></div><div><br></div></div>
</blockquote></div><br></div></div>