[DB-SIG] How to best connect to AS/400 for data

[Vernon Cole]

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 <jim at 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 at python.org
> http://mail.python.org/mailman/listinfo/db-sig
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/db-sig/attachments/20100224/702f9394/attachment.html>