ZF-11940: Problem with connecting to IDS with pdo_ibm driver

Issue Type: Improvement Created: 2011-12-15T07:13:33.000+0000 Last Updated: 2012-11-16T18:43:46.000+0000 Status: Open Fix version(s): Reporter: Marek Przybysz (marekprzybysz) Assignee: None Tags: - Zend_Db

  • NeedsPatch

Related issues: Attachments:


I am having a problem with acquiring a new connection to an IDS database using pdo_ibm driver. Connection string: "ibm: DRIVER={IBM DB2 ODBC DRIVER};DATABASE=zbo; HOSTNAME=IP_ADDR;PORT=9088;PROTOCOL=TCPIP; " I get an error:

SQLSTATE=08001, SQLDriverConnect: -30081 [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "IP_ADDR". Communication function detecting the error: "recv". Protocol specific error code(s): "", "", "0". SQLSTATE=0800 which I was unable to decipher having the available documentation. Database configuration is also limited due to the fact that it is constantly working in production mode.

I have managed to come up with a workaround by using this connection string "informix: host=IP_ADDR; service=9088; database=zbo; server=db; protocol=onsoctcp; DB_LOCALE=pl_PL.1250; Client_Locale=pl_pl.1250" and setting specifically IDS in Zend_Db_Adapter_Pdo_Ibm:_connect()

I would ask to You, for the future version of Zend, to make Zend\Db\Adapter\Pdo\Ibm\Ids.php a seprate Zend_Db_Adapter_Pdo_Abstract with "informix" as a _pdoType.


Posted by Rob Allen (rob) on 2012-11-16T18:43:19.000+0000

If you are prepared to sign the CLA (…) and provide a patch, I'm happy to review it.

Have you found an issue?

See the Overview section for more details.


© 2006-2018 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.