<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html><head> <meta content="text/html; charset=utf-8" http-equiv="Content-Type"> </head>Vernon<br/><br/>Thanks for the info. Will this run under linux with iSeries Access for Linux installed?<br/><br/>Jim<br/><br/> <p>Jim Steil<br/>VP of Information Technology<br/>Quality Liquid Feeds, Inc.<br/>608.935-2345 phone<br/>608.341.9896 cell</p><hr/><div><b>From: </b> Vernon Cole <vernondcole@gmail.com>
</div><div><b>Date: </b>Wed, 24 Feb 2010 13:15:13 -0700</div><div><b>To: </b>Jim Steil<jim@qlf.com></div><div><b>Cc: </b><db-sig@python.org></div><div><b>Subject: </b>Re: [DB-SIG] How to best connect to AS/400 for data</div><div><br/></div>Jim:<br>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.<br>
<br>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.<br>
<br>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.<br>
<br>4) If you want to try this, please use the new test version of adodbapi which is in the Mercurial source tree at <a href="http://sourceforge.net/projects/adodbapi/develop">http://sourceforge.net/projects/adodbapi/develop</a>. [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.<br>
--<br>Vernon Cole<br><br><div class="gmail_quote">On Wed, Feb 24, 2010 at 9:57 AM, Jim Steil <span dir="ltr"><<a href="mailto:jim@qlf.com">jim@qlf.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi<br>
<br>
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 <a href="http://code.google.com/p/ibm-db/wiki/README" target="_blank">http://code.google.com/p/ibm-db/wiki/README</a>, but can't get past the first part that says:<br>
<br>
The IBM_DB_SA adapter is packages as a Python Egg component and is dependent on:<br>
<br>
SQLAlchemy 0.4.0 (I assume 0.5.8 will work as well)<br>
IBM_DB_DBI Python wrapper<br>
IBM_DB Python driver<br>
IBM Data Server Driver Version 9<br>
<br>
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?<br>
<br>
Any help would really be appreciated.<br>
<br>
-Jim<br>
<br>
_______________________________________________<br>
DB-SIG maillist - <a href="mailto:DB-SIG@python.org" target="_blank">DB-SIG@python.org</a><br>
<a href="http://mail.python.org/mailman/listinfo/db-sig" target="_blank">http://mail.python.org/mailman/listinfo/db-sig</a><br>
</blockquote></div><br>
</html>