php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #37680 PHP 4.3.11 to PHP 5.1.4
Submitted: 2006-06-02 14:52 UTC Modified: 2006-06-06 07:56 UTC
From: gnanavelan dot muthukrishnan at kumaran dot com Assigned:
Status: Not a bug Package: Sybase-ct (ctlib) related
PHP Version: 5.1.4 OS: Linux
Private report: No CVE-ID: None
 [2006-06-02 14:52 UTC] gnanavelan dot muthukrishnan at kumaran dot com
Description:
------------
We are migrating from php 4.3.11 to php 5.1.4. The connection has established using mssql_pconnect().
But sybase_query() using that link id is not working in php 5.1.4 whereas it works in php 4.3.11.

Same way the link id returned by sybase_pconnect() does not work for mssql_query(). but this works in php 4.3.11.

Below source code used the link id of mssql_pconnect()

Reproduce code:
---------------
$sSQL = "SELECT * FROM DISTRIBUTOR where distributor_number = ".$_REQUEST['dist_id'];
echo "<br> ssql " .$sSQL;
echo "<br> Link id " .$Link_ID;
$rc = sybase_query($sSQL , $Link_ID);
echo "<br> rc ".$rc;


Expected result:
----------------
ssql SELECT * FROM DISTRIBUTOR where distributor_number = 1
Link id Resource id #6
rc Resource id #10 



Actual result:
--------------
ssql SELECT * FROM DISTRIBUTOR where distributor_number = 1
Link id Resource id #6
rc 

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-06-05 15:50 UTC] iliaa@php.net
if you use sybase_connect() does the code work as expected?
 [2006-06-06 07:39 UTC] gnanavelan dot muthukrishnan at kumaran dot com
Yes for sybase_query(), if i use sybase_pconnect it works fine. Simlarly for mssql_query(), if the i use mssql_pconnect, it works fine.
 [2006-06-06 07:56 UTC] tony2001@php.net
Yes, ext/mssql and ext/sybase are different extensions.
For some weird reason ext/sybase contains mssql_* aliases, but not when ext/mssql enabled.
See bug #32531 for details.
 
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Mon Feb 24 05:01:26 2020 UTC