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

[M.-A. Lemburg]

Jim Steil wrote:
> 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.

You'd need SA support for the SQL dialect to get that working.
Perhaps there's a way to port the IBM SA driver to SA 0.5. There's
work underway to get mxODBC support into SA as well.

> 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.

Yes, it's a commercial product that we've maintained for the last
12-13 years and for which we provide commercial support.

Anyway, I was just trying to suggest a method that is known to
work and may save you a few days work :-)

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/


>    -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 at python.org
> http://mail.python.org/mailman/listinfo/db-sig