RE: PHP access to Informix-SE

The respective doc's say you have to use onsoctcp on the Linux side and setlitcp on the Informix-SE side. Will those two communicate OK? Walt. From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Art Kagel Sent: Thursday, January 21, 2010 2:21 PM To: Obnoxio The Clown Cc: informix-list@iiug.org Subject: Re: PHP access to Informix-SE Obnoxio, AFAIK Online and SE use the same SQLI protocol as IDS. The last change to the basic protocol was in Online 5.06/5.07 (.07 fixed performance bugs in the 'new' protocol introduced in 5.06), IDS has just extended it to support new data types, etc. Since SE uses the same sqlexecd as Online... Art Art S. Kagel Advanced DataTools (www.advancedatatools.com<http://www.advancedatatools.com>) IIUG Board of Directors (art@iiug.org<mailto:art@iiug.org>) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf<http://www.iiug.org/conf>; Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jan 21, 2010 at 2:06 PM, Obnoxio The Clown <obnoxio@serendipita.com<mailto:obnoxio@serendipita.com>> wrote: Hultgren, Walt wrote: > I'm attempting to set up access to an Informix-SE database on a Sun > server from a Web server running Apache/PHP on CentOS. So far, I'm > having no success. Here's the environment -- the two versions each of > Apache and PHP mean that I've tried them in various combinations: > > > > Web Server: > > - CentOS 5.4 > > - Apache 2.2.3 (w/CentOS), 2.0.63 (compiled locally) > > - PHP 5.1.6 (w/CentOS), 5.3.1 (compiled locally) > > - PDO Informix 1.2.6 > > - Informix Client SDK 3.50.FC6 > > > > Database Server: > > - Sun Solaris 10 > > - Informx-SE 7.25.UC7 > > > > One question I have is whether I need Informix Client SDK or Informix > Connect on the db server for this type of access. I don't currently > have it, but just run sqlexecd. I can successfully connect to the Sun > db server from a different Sun box using Informix tools (dbaccess, isql,...). > > > > The two errors I see the most are when attempting PHP access from the > CentOS box are "-11005: Invalid connection string attribute" from PHP, > and (when I actually make it across to the Sun box) "-408: Invalid > message type received from the sqlexec process" in the sqlexecd log. I > can connect to the Sun db server from a different Sun box using Informix > tools (dbaccess, isql,...) with no problem. > > > > All of the info I've been able to find on the Web and various forums is > geared toward IDS, and most of it is a little dated at this point. > > > > If anyone has this type of set-up (or something close) working, I'd > appreciate any suggestions you have, including which versions of the > various packages to use. Uh, gosh, that's a bit of a poser. Like the man says, I don't know the answer, but I do admire the problem. I was under the impression that this couldn't actually be done ... I didn't think that the client SDK "spoke" SE (or OnLine, for that matter!) Am I just addlepated? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. _______________________________________________ Informix-list mailing list Informix-list@iiug.org<mailto:Informix-list@iiug.org> http://www.iiug.org/mailman/listinfo/informix-list ________________________________ This e-mail message (including any attachments) is for the sole use of the intended recipient(s) and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this message (including any attachments) is strictly prohibited. If you have received this message in error, please contact the sender by reply e-mail message and destroy all copies of the original message (including attachments).