Jim Steil 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.
I'd suggest to have a look at the "System i Access for Linux":
http://www-03.ibm.com/systems/i/software/access/linux/index.html
For Windows, use this link:
http://www-03.ibm.com/systems/i/software/access/windows/index.html
I can't say how well the above setup works, but at least SA has
moved forward a lot since the 0.4 days.
We have a few clients running DB2 on System i/iSeries/AS/400. They
use the ODBC driver from the above site together with our
mxODBC driver to connect to the database from Linux and Windows:
http://www.egenix.com/products/python/mxODBC/
Regards,
--
Marc-Andre Lemburg
eGenix.com
Professional Python Services directly from the Source (#1, Feb 24 2010)
>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
________________________________________________________________________
::: Try our new mxODBC.Connect Python Database Interface for free ! ::::
eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48
D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
Registered at Amtsgericht Duesseldorf: HRB 46611
http://www.egenix.com/company/contact/
_______________________________________________
DB-SIG maillist - DB-SIG@python.org
http://mail.python.org/mailman/listinfo/db-sig
