I don't have a problem accessing AS400 data from python but I've been
using pyodbc on my Windows systems. But, I now want to move to linux
for running my Python apps and would prefer to use SQLAlchemy to access
my dbs. So, I'm looking for a way to get SQLAlchemy talking to the 400.
mx.ODBC is a licensed product, isn't it? I've tried it in the past, but
would (of course) prefer to avoid the licensing costs.
-Jim
M.-A. Lemburg wrote:
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,
_______________________________________________
DB-SIG maillist - DB-SIG@python.org
http://mail.python.org/mailman/listinfo/db-sig
