Informix is a commercial product that is not cheap to keep running so I'd assume you're working for a commercial entity with IBM support? Perhaps you can get support from Rahul at IBM to either improve sqlalchemy-informixdb (or they can just take it) or the ibm_db_sa product ? The improvement and modernization of the ibm_db_sa adapter in the first place was due to engagements with clients that IBM supports. I have a relationship with Rahul to the degree that he can throw me questions as he needs and I've submitted patches to the project as well.
On May 19, 2014, at 10:51 AM, Massimo Valle <[email protected]> wrote: > > 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?: ibm_db_dbi::DatabaseError?: SQLNumResultCols > failed: IBM?Driver?[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 <[email protected]> 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 [email protected]. >> To post to this group, send email to [email protected]. >> 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 [email protected]. > To post to this group, send email to [email protected]. > 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
