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 -----Original Message----- From: Vernon Cole <vernondc...@gmail.com> Date: Wed, 24 Feb 2010 13:15:13 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
