ID: 19982
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Closed
Bug Type: ODBC related
Operating System: RedHat 6.2
PHP Version: 4.2.3
New Comment:
Note your solution is typically a Bad Idea (TM). The configure script
should detect if a system is capable of handling a SQLExtendedFetch or
not.
While I know that iODBC does support the ExtendedFetch (thus it works
for your issue), it preplexes me that it does not find the
EXTENDED_FETCH flag in your build. You should note that
ext/odbc/php_odbc_includes.h does pretty much the same solution...
Previous Comments:
------------------------------------------------------------------------
[2002-11-06 09:53:04] [EMAIL PROTECTED]
To solve this problem:
Edit php_odbc.h and delete all rows
'#define HAVE_SQL_EXTENDED_FETCH 1'
and recompile PHP.
------------------------------------------------------------------------
[2002-11-06 03:49:50] [EMAIL PROTECTED]
Notes:
'--with-informix'
Imho it should be "-with-informix=yes". But if you make (make install)
worked, that should be no problem.
Why do you use a
=> $db = odbc_connect("$dsn", "$user", "$password");
if you could use a
=> $connect = ifx_connect("$database@IFX_SERVER", "$user",
"$password");
?
To your problem:
What happens if you run the statment:
"Select codice,name,address, zipnum from clienti, ziptable where codice
= zipcode and codice = '$codice'"
in DBACCESS?
Please give me examples for "codice", "zipcode" and "$codice". (Since
JOIN here.)
"This script fail..."
I assume there is no error?
Regards,
Claus
------------------------------------------------------------------------
[2002-10-21 02:37:10] [EMAIL PROTECTED]
**** The SQL log ****
[0] SQLAllocHandle
handleType=1
[0] SQLAllocHandle: returning SQL_SUCCESS
[0] SQLSetEnvAttr hEnv=DBD0001
Attribute=200 ValuePtr=2 StringLength=0
[0] SQLSetEnvAttr: returning SQL_SUCCESS
[0] SQLAllocHandle hEnv=DBD0001
handleType=2
[0] SQLAllocHandle: returning SQL_SUCCESS
[0] SQLConnect hDbc=DBD0002
szDSN=820012C cbDSN=-3 szUID=8200114 cbUID=-3 szPWD=82000FC cbPWD=-3
DSN=gaia;UID=gaeuro;PWD=erre1
connStr=[DSN]
key=[DSN] data=[gaia] supplied=1
key=[DATABASE] data=[/usr/serv1/gaeuro/exe/dbgaia/gaia] supplied=0
key=[OPTIONS] data=[] supplied=0
key=[UID] data=[gaeuro] supplied=1
key=[READONLY] data=[] supplied=0
key=[HOST] data=[10.30.0.33] supplied=0
key=[PORT] data=[5000] supplied=0 key=[SVT] data=[Informix 7.2]
supplied=0
key=[FBS] data=[99] supplied=0
key=[NLB] data=[Yes] supplied=0
key=[PROTO] data=[TCP/IP] supplied=0
key=[DLF] data=[] supplied=0
cn_dbpath=[/usr/serv1/gaeuro/exe/dbgaia/gaia] cn_dbopts=[]
cn_readonly=0
cn_fetchSize=99 cn_dbhost=[10.30.0.33] cn_svtype=[Informix 7.2]
cn_deferlongfetch=0
cn_needbind=1
cn_hasMoreRes=1
cn_hasParamOp=0
cn_hasScrlCurs=1
cn_hasDynMixCurs=0
cn_hasV2DAE=0
cn_spOutDeferFetch=0
cn_hasExecute2=0
autocommit=1
[0] SQLConnect: returning SQL_SUCCESS
[0] SQLGetInfo hDbc=DBD0002
fInfoType=23 rgbInfoValue=81F6CA4 cbInfoValueMax=2 pcbInfoValue=0
[0] SQLGetInfo: returning SQL_SUCCESS
[0] SQLGetInfo hDbc=DBD0002
fInfoType=24 rgbInfoValue=81F6CA6 cbInfoValueMax=2 pcbInfoValue=0
[0] SQLGetInfo: returning SQL_SUCCESS
[0] SQLAllocHandle hDbc=DBD0002
handleType=3
[0] SQLAllocHandle: returning SQL_SUCCESS
[0] SQLGetStmtAttr hStmt=DBD0003
Attribute=10010 ValuePtr=081F98C4 BufferLength=0
StringLengthPtr=00000000
[0] SQLGetStmtAttr: returning SQL_SUCCESS
[0] SQLGetStmtAttr hStmt=DBD0003
Attribute=10011 ValuePtr=081F98EC BufferLength=0
StringLengthPtr=00000000
[0] SQLGetStmtAttr: returning SQL_SUCCESS
[0] SQLGetStmtAttr hStmt=DBD0003
Attribute=10012 ValuePtr=081F9914 BufferLength=0
StringLengthPtr=00000000
[0] SQLGetStmtAttr: returning SQL_SUCCESS
[0] SQLGetStmtAttr hStmt=DBD0003
Attribute=10013 ValuePtr=081F993C BufferLength=0
StringLengthPtr=00000000
[0] SQLGetStmtAttr: returning SQL_SUCCESS
[0] SQLGetInfo hDbc=DBD0002
fInfoType=8 rgbInfoValue=BFFFDA1C cbInfoValueMax=4 pcbInfoValue=0
[0] SQLGetInfo: returning SQL_SUCCESS
[0] SQLSetStmtAttr hStmt=DBD0003
Attribute=6 ValuePtr=00000002 StringLength=0
[0] SQLSetStmtAttr: returning SQL_SUCCESS_WITH_INFO
[0] SQLExecDirect hStmt=DBD0003
szSqlStr=81F9204 cbSqlStr=-3
[Select a_sigla_art, a_descr_art, sc_descr from art, sco where
sc_cod_s_conto=a_cod_forn]
[0] SQLExecDirect: returning SQL_SUCCESS
[0] SQLNumResultCols hStmt=DBD0003
pccol=BFFFD9CA
[0] SQLNumResultCols: returning SQL_SUCCESS
[0] SQLNumResultCols hStmt=DBD0003
pccol=BFFFD9DA
[0] SQLNumResultCols: returning SQL_SUCCESS
[0] SQLColAttribute hStmt=DBD0003
icol=1 fDescType=1011 rgbDesc=081F995C cbDescMax=32 pcbDesc=BFFFD9FE
pfDesc=00000000
[0] SQLColAttribute: returning SQL_SUCCESS
[0] SQLColAttribute hStmt=DBD0003
icol=1 fDescType=2 rgbDesc=00000000 cbDescMax=0 pcbDesc=00000000
pfDesc=081F9984
[0] SQLColAttribute: returning SQL_SUCCESS
[0] SQLColAttribute hStmt=DBD0003
icol=1 fDescType=6 rgbDesc=00000000 cbDescMax=0 pcbDesc=00000000
pfDesc=BFFFD9F8
[0] SQLColAttribute: returning SQL_SUCCESS
[0] SQLBindCol hStmt=DBD0003
icol=1 fCType=1 rgbValue=81F8E3C cbValueMax=19 pcbValue=81F9980
[0] SQLBindCol: returning SQL_SUCCESS
[0] SQLColAttribute hStmt=DBD0003
icol=2 fDescType=1011 rgbDesc=081F9988 cbDescMax=32 pcbDesc=BFFFD9FE
pfDesc=00000000
[0] SQLColAttribute: returning SQL_SUCCESS
[0] SQLColAttribute hStmt=DBD0003
icol=2 fDescType=2 rgbDesc=00000000 cbDescMax=0 pcbDesc=00000000
pfDesc=081F99B0
[0] SQLColAttribute: returning SQL_SUCCESS
[0] SQLColAttribute hStmt=DBD0003
icol=2 fDescType=6 rgbDesc=00000000 cbDescMax=0 pcbDesc=00000000
pfDesc=BFFFD9F8
[0] SQLColAttribute: returning SQL_SUCCESS
[0] SQLBindCol hStmt=DBD0003
icol=2 fCType=1 rgbValue=81F9AAC cbValueMax=41 pcbValue=81F99AC
[0] SQLBindCol: returning SQL_SUCCESS
[0] SQLColAttribute hStmt=DBD0003
icol=3 fDescType=1011 rgbDesc=081F99B4 cbDescMax=32 pcbDesc=BFFFD9FE
pfDesc=00000000
[0] SQLColAttribute: returning SQL_SUCCESS
[0] SQLColAttribute hStmt=DBD0003
icol=3 fDescType=2 rgbDesc=00000000 cbDescMax=0 pcbDesc=00000000
pfDesc=081F99DC
[0] SQLColAttribute: returning SQL_SUCCESS
[0] SQLColAttribute hStmt=DBD0003
icol=3 fDescType=6 rgbDesc=00000000 cbDescMax=0 pcbDesc=00000000
pfDesc=BFFFD9F8
[0] SQLColAttribute: returning SQL_SUCCESS
[0] SQLBindCol hStmt=DBD0003
icol=3 fCType=1 rgbValue=81F6D5C cbValueMax=31 pcbValue=81F99D8
[0] SQLBindCol: returning SQL_SUCCESS
[0] SQLRowCount hStmt=DBD0003
pcrow=BFFFDA24
[0] SQLRowCount: returning SQL_SUCCESS
[0] SQLExtendedFetch hStmt=DBD0003
fFetchType=1 irow=0 pcrow=BFFFDA1C rgfRowStatus=BFFFDA22
[0] SQLExtendedFetch: returning SQL_ERROR
[0] SQLExtendedFetch hStmt=DBD0003
fFetchType=5 irow=1 pcrow=BFFFDA1C rgfRowStatus=BFFFDA22
[0] SQLExtendedFetch: returning SQL_NO_DATA_FOUND
[0] SQLExtendedFetch hStmt=DBD0003
fFetchType=1 irow=0 pcrow=BFFFDA1C rgfRowStatus=BFFFDA22
[0] SQLExtendedFetch: returning SQL_NO_DATA_FOUND
[0] SQLExtendedFetch hStmt=DBD0003
fFetchType=5 irow=1 pcrow=BFFFDA1C rgfRowStatus=BFFFDA22
[0] SQLExtendedFetch: returning SQL_NO_DATA_FOUND
[0] SQLFreeHandle hStmt=DBD0003
handleType=3
[0] SQLFreeHandle: returning SQL_SUCCESS
[0] SQLDisconnect hDbc=DBD0002
[0] SQLDisconnect: returning SQL_SUCCESS
------------------------------------------------------------------------
[2002-10-18 13:30:53] [EMAIL PROTECTED]
hrm, any chance you can turn on SQL logging?
------------------------------------------------------------------------
[2002-10-18 13:17:37] [EMAIL PROTECTED]
I'm using Openlink Multi Tier Driver for accessing a Informix 7.2
Database on a Linux box from PHP scripts running on the Apache Web
Server on a different Linux Box.
PHP version 4.2.3
Openlink version 4.2.7
Apache Version 1.3.12
I'm tested Openlink driver and DSN setup with Openlink test program
odbctest: It work fine.
This script work fine:
<?
$db = odbc_connect("$dsn", "$user", "$password");
$sql = "Select codice,name,address from clienti where codice =
'$codice'";
if($result = odbc_do($db, $sql))
{if($db1 = odbc_fetch_into($result, $myrow))
do{printf("
........
}while((odbc_fetch_into($result, $myrow));
}
?>
This script fail... (The same sql statement work fine with odbctest)
<?
$db = odbc_connect("$dsn", "$user", "$password");
$sql = "Select codice,name,address, zipnum from clienti, ziptable where
codice = zipcode and codice = '$codice'";
if($result = odbc_do($db, $sql))
{// The $result connect string is OK and the correct
// number of rows is returned....
$numrows = odbc_num_rows($result); // O.K.
// Nothing is returned from the following function..
if($db1 = odbc_fetch_into($result, $myrow))
do{printf("
........
}while((odbc_fetch_into($result, $myrow));
}
?>
odbc_fetch_row also returns nothing.
PHP configuration:
./configure' '--with-apxs=/usr/sbin/apxs' '--with-ftp'
'--with-config-file-path=/etc/httpd' '--with-informix'
'--with-iodbc=/usr/local/openlink/odbcsdk'
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=19982&edit=1
