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@python.org > http://mail.python.org/mailman/listinfo/db-sig _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
