Sorry! I was assuming a Windows environment. Someday, using IronPython under Mono, but not yet. -- Vernon
On Wed, Feb 24, 2010 at 1:32 PM, <j...@qlf.com> wrote: > Vernon > > Thanks for the info. Will this run under linux with iSeries Access for > Linux installed? > > Jim > > Jim Steil > VP of Information Technology > Quality Liquid Feeds, Inc. > 608.935-2345 phone > 608.341.9896 cell > ------------------------------ > *From: * Vernon Cole <vernondc...@gmail.com> > *Date: *Wed, 24 Feb 2010 13:15:13 -0700 > *To: *Jim Steil<j...@qlf.com> > *Cc: *<db-sig@python.org> > *Subject: *Re: [DB-SIG] How to best connect to AS/400 for data > > Jim: > 1) I have successfully accessed AS/400 SQL data using adodbapi and IBM > Client Access Express. (You must install the ADO option for CAExpress, which > is not part if the default.) I have a production program which has been > using that combination for several years. > > 2) adodbapi was supposed to work with SQLalchemy last time I checked. It > was not the preferred platform, but I have tried to add some requested > features to make adodbapi more SQLAlchemy friendly. In particular, > cursor.rowcount almost always works now. > > 3) Given the above two facts, it might be possible to use adodbapi, > SQLAlchemy, and CAExpress to do what you want. Be warned, however: the IBM > dialect of SQL is pretty weird -- I tried to add AS/400 tests to the > adodbapi test suite and gave up in frustration. It may take some work to get > them playing well together. > > 4) If you want to try this, please use the new test version of adodbapi > which is in the Mercurial source tree at > http://sourceforge.net/projects/adodbapi/develop. [Note: NOT the CVS > tree.] The refactoring was mostly to add django support, but any changes to > help with SQLAlchemy should go into that version. Early reports say that > the new version works okay. > -- > Vernon Cole > > On Wed, Feb 24, 2010 at 9:57 AM, Jim Steil <j...@qlf.com> wrote: > >> Hi >> >> I'm looking to use SQLAlchemy to connect to my AS/400 and manipulate data. >> However, I'm totally lost on where to start and what IBM drivers I need to >> do so. Is there anyone out there that can get me started on the right path? >> I've already been pointed to http://code.google.com/p/ibm-db/wiki/README, >> but can't get past the first part that says: >> >> The IBM_DB_SA adapter is packages as a Python Egg component and is >> dependent on: >> >> SQLAlchemy 0.4.0 (I assume 0.5.8 will work as well) >> IBM_DB_DBI Python wrapper >> IBM_DB Python driver >> IBM Data Server Driver Version 9 >> >> I don't know where to get this IBM Data Server Driver Version 9. And, can >> I just easy_install the other two IBM_DB components? >> >> Any help would really be appreciated. >> >> -Jim >> >> _______________________________________________ >> DB-SIG maillist - DB-SIG@python.org >> http://mail.python.org/mailman/listinfo/db-sig >> > >
_______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
