[Product-Developers] collective.lead an ODBC iSeries DB2 Database

[Christian Klinger]

Hi,

i try to connect with collective.lead to an iSeries DB2 Database.
I use the pyodbc python module for this.

This piece of code is working:
-------------------------------------------------------------
import pyodbc
conn = pyodbc.connect('DSN=AS400')
curs = conn.cursor()
curs.execute('select count(edokimp_id) from edokimp')
print curs.fetchall()
-------------------------------------------------------------

Now some questions:

Is it possible to use pyodbc with sqlalchemy and collective.lead?
How do i specify my sa.engine.url.URL?

class MyDatabase(Database):
     @property
     def _url(self):
         return sa.engine.url.URL(????)

Is it a good idea to post this to sqlalchemy too?

Thanks for help.