SQLAlchemy and adodbapi Database connection error
===

I'm attempting to connect to a mssql SQLExpress 2012 database using sqlalchemy 0.7.8 and adodapi 2.4.2.2 on IronPython 2.7.3

I am able to create a sqlalchemy engine, however when a query is made I get : 
"TypeError: 'NoneType' object is unsubscriptable"

TraceBack:

    Traceback (most recent call last):
      File "C:\Program Files (x86)\IronPython 2.7\Lib\site-packages\SQLAlchemy-0.7.8-py2.7.egg\sqlalchemy\engine\base.py", line 878, in __init__
      File "C:\Program Files (x86)\IronPython 2.7\Lib\site-packages\SQLAlchemy-0.7.8-py2.7.egg\sqlalchemy\engine\base.py", line 2558, in raw_connection
      File "C:\Program Files (x86)\IronPython 2.7\Lib\site-packages\SQLAlchemy-0.7.8-py2.7.egg\sqlalchemy\pool.py", line 183, in unique_connection
      File "<string>", line 9, in <module>
      File "C:\Program Files (x86)\IronPython 2.7\Lib\site-packages\SQLAlchemy-0.7.8-py2.7.egg\sqlalchemy\engine\base.py", line 2472, in connect
    TypeError: 'NoneType' object is unsubscriptable

Code being used:

    def conn():
	    return adodbapi.connect('Provider=SQLOLEDB; Data Source=SERVER\SQLEXPRESS; 
                                 Initial Catalog=db; User ID=user; Password=pass;')
    engine = create_engine('mssql+adodbapi:///', creator=conn, 
                            echo = True, module=adodbapi)

adodbapi seems to work fine on it's own, ie. i can create a connection and then use a cursor to query without any problems, it seems to be something in sqlalchemy.

Anyone any ideas?


