My problem with InformixDB (I tried it) is it seems too weakly supported/used, while I need something more reliable, sorry. ibm_db seems more stable but the problem is with the "ibm_db_sa" adapter (SQLAlchemy module). My problem is when I try the "IBM_DB SA adapter sanity test" as from the project wiki (https://code.google.com/p/ibm-db/wiki/README). I always get this error:
ibm_db_dbi.DatabaseError?<https://code.google.com/p/ibm-db/w/edit/DatabaseError>: ibm_db_dbi::DatabaseError?<https://code.google.com/p/ibm-db/w/edit/DatabaseError>: SQLNumResultCols failed: IBM? <https://code.google.com/p/ibm-db/w/edit/IBM> Driver? <https://code.google.com/p/ibm-db/w/edit/CLI>[IDS/UNIX32] The specified table (sysibm.sysdummy1) is not in the database. SQLCODE=-206 The same happens when creating a Session() in SQLAlchemy. It seems the ibm_db_sa adapter thinks to DB2 only and try to query the sysibm.sysdummy1 system table, which is not present in Informix. On the same wiki page I commented about this fact, and a project member (Rahul) (with an @ibm.com email address) answered: "Informix is currently not supported for SQLALchemy's ibm_db_sa backend." Btw, since I'm new to SQLAlchemy, I don't understand the full implications of this, and that was my question about the ability to use the ORM or just the Core features. Thanks for help, Massimo On Monday, May 19, 2014 3:37:12 PM UTC+2, Michael Bayer wrote: > > we’ve had a dedicated Informix dialect in the past, however I’m unable to > maintain it because I don’t have any way to test it, it was contributed by > someone many years ago. The dialect was moved out to > https://bitbucket.org/zzzeek/sqlalchemy-informixdb, and most of what’s > needed for it to work should be there. It might need some tweaks to get it > going, e.g. with getting the setuptools entry point to be correct and all > that, but overall it should have what’s needed for rudimental access. > > Also I’m not sure why ibm_db_sa advertises informix support when this is > not the case, can you elaborate on this? do they support only connectivity > but not actually the right SQL format? > > > > On May 19, 2014, at 7:50 AM, Massimo Valle <vall...@gmail.com<javascript:>> > wrote: > > I'm exploring SQLAlchemy features for a new project which must use an IBM > Informix database. > Found the ibm_db and ibm_db_sa modules to integrate with SQLAlchemy and > successfully connected to the database after some tries. > > I found the ibm_db_sa module only supports DB2 and NOT Informix. At least > this is what was answered me on the project page. > > Now I have a couple of newbie questions for the SQLAlchemy experts: > > 1. Does anyone know if the Informix support is something will be added? > (planned, considering). I don't know if this module is developed from IBM > or SQLAlchemy so, I'm not even sure to whom address this question. > 2. I see, I can connect to my Informix database, but can't use the > ibm_db_sa module. Does this mean I can only use SQLAlchemy Core features > and not the ORM? That would be sad since the ORM is exactly what I planned > to use. > > Thanks for help, > > Massimo Valle > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+...@googlegroups.com <javascript:>. > To post to this group, send email to sqlal...@googlegroups.com<javascript:> > . > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
