An ODBC interface for Python 3?

Roger Upole rupole at
Sat Jul 2 10:12:54 EDT 2011

kozmikyak wrote:
> Does anyone here have a Python 3 environment that can access MSSQL
> using SQLAlchemy, running on a Windows 7 box?  If so, I would like
> some assistance making it happen.
> The last post on this was mid-2010.  It was mentioned that pyodbc had
> a Python 3 branch.  I've been unable to get it compiled and working on
> Windows 7 32-bit or 64-bit, even after applying patches mentioned in
> one of the project's tracking issues.
> Right now anyone forced to support Windows clients, Microsoft SQL, and
> SQLAlchemy has no option if wanting to use Python 3.2.  Neither
> pymssql or pyodbc compiles out-of-the-box for Python 3.2.  ceODBC
> compiles and runs, but SQLAlchemy project has stated that it has no
> desire to write yet another dialect supporting ceODBC for MSSQL.
> I'm not mentioning this just to complain; I'm just stating it out in
> the open so that it's known.  Indeed, even if one doesn't want to use
> MSSQL, the only free ODBC interface I know of that works on Python 3
> is ceODBC, and it is not supported by other modules such as
> SQLAlchemy.
> I'm wondering how I could best make something like this happen.  I've
> written to the SQLAlchemy and pyodbc projects.  I have average Python
> programming skills and have a Windows Python environment with C
> compiler installed; perhaps if the authors respond I can assist.
> If someone else has already figured out how to make this happen,
> please let me know.

Pywin32 has an odbc module that works with Python 3.2.


More information about the Python-list mailing list