pyodbc module does not work with Python3
<p>I have just transitioned to a Mac (from Win) and I cannot find the proper way to make a script work (it did on Win).</p>

<p>I am using <code>import pyodbc</code> on the first line and I get the "No module .." error.</p>

<p><em>Later Edit</em>: I changed the first line to <code>import pypyodbc</code></p>

<p>If I enter the workspace in the preexistent python version (2.7.10) I can import the module but the script fails with:</p>

<pre><code>pyodbc.Error: ('00000', '[00000] [iODBC][Driver Manager]dlopen({SQL Server}, 6): image not found (0) (SQLDriverConnect)')
</code></pre>

<p>I want to use python3 anyway.</p>

<p>If I enter python3, when trying to import the module I get an error.</p>

<p>My main problem is that I an not sure how to find where the problem is. Can anyone help with this?</p>

<p><strong>Later Edit</strong></p>

<p>It worked if I used <code>pypyodbc</code> instead of <code>pyodbc</code>. It imports the module and the only thing left to solve is the decoding part: <code>UnicodeDecodeError: 'utf-32-le' codec can't decode bytes in position 0-1: truncated data</code></p>