ID: 19982 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Feedback +Status: Open Bug Type: ODBC related Operating System: RedHat 6.2 PHP Version: 4.2.3 New Comment:
**** 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 Previous Comments: ------------------------------------------------------------------------ [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