php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #15628 Multiple Connections not allowed
Submitted: 2002-02-19 14:29 UTC Modified: 2002-07-19 01:00 UTC
Votes:3
Avg. Score:5.0 ± 0.0
Reproduced:3 of 3 (100.0%)
Same Version:3 (100.0%)
Same OS:0 (0.0%)
From: ekonig at yahoo dot com Assigned:
Status: No Feedback Package: Informix related
PHP Version: 4.1.1 OS: SunSolaris 8 Sparc
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: ekonig at yahoo dot com
New email:
PHP Version: OS:

 

 [2002-02-19 14:29 UTC] ekonig at yahoo dot com
Hi,

I would like to report a bug in the Informix module of PHP 4.1.1.

When you try to use more than one connection, the last connection created is the one that receives every statement, and under this circumstances you may get a SQLCODE error code -206 when calling ifx_query as the table may not exist in the current database. 

I was debugging the Informix implementation and I found that in the function ifx_query the following statement is missing:

  EXEC SQL set connection :ifx;

before the call of the macro PHP_IFX_CHECK_CONNECTION and the call to the PREPARE statement. If you add that statement, the funcion ifx_query works fine.

This function call is needed as every time that you execute the statement CONNECT TO ... that connection is the active one and the former connections become dormant. When you want to use one of those connection, you need to active it again using the statement SET CONNECTION.

I hope this helps.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-02-22 12:22 UTC] roger at wzero dot com dot br, paulo at tramontina dot net
we?ve found the same bug.
This solution worked very well!
Thanks!
 [2002-02-22 12:25 UTC] roger at wzero dot com dot br, paulo at tramontina dot net
Some information:

SO - Red Hat 7.1 kernel 2.2.12

The file to be edited is ext/informix/ifx.ec
 [2002-04-19 14:35 UTC] thomas dot hoppe at daimlerchrysler-bank dot com
I have the exactly same problem with Oracle!!!
 [2002-06-18 05:30 UTC] derick@php.net
can you please provide a patch for this?

Derick
 [2002-07-19 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 [2005-12-07 15:30 UTC] kucera_pavel at centrum dot cz
Thank you for perfect solution. 

Pavel K.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Mar 28 23:01:26 2024 UTC