Informix and DB

From: Date: Wed, 14 May 2003 11:58:13 +0000
Subject: Informix and DB
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-5364@lists.php.net to get a copy of this message
We are in the process of porting our system from PostgreSQL to Informix. We are currently using PEAR::DB with PostgreSQL and are quite happy with it. The description of PEAR::DB states that informix is currently supported. But we have had problems. I can connect to the informix db all right, but when I want to manipulate fields of the type "text" (which informix treats as blob's), I get the error: [SQLSTATE=00 000 SQLCODE=-611] Scroll cursor can't select blob columns. And that's just for starters. We have also tried ADODB, also with little success. Is there anyone out there that has experience in using PEAR DB with Informix, or even better, experience in porting from PostgreSQL to Informix? Any pointers (other than NULL) will be greatly appreciated. Regards. Baldur Eiríksson University of Iceland Computing Services <mailto:baldure@hi.is> baldure@hi.is

« previous php.pear.general (#5364) next »