#19528 [Opn->Fbk]: odbc_fetch_row() doesn't returned true if there is one row only

ID: 19528 Updated by: kalowsky@php.net Reported By: scott at abcoa dot com -Status: Open +Status: Feedback Bug Type: ODBC related Operating System: AIX (UNIX) PHP Version: 4.2.2 New Comment: To answer some of the comments in here, yes unixODBC is a Driver Manager much in the same vain as iODBC. The reason for asking is that while PHP does support DB2, I (as the developer) have no direct access to a DB2 machine to test if anything at all works on it. The unixODBC DM is actually the suggested and prefered method by IBM for connecting to a DB2 installation, not directly through library linking like you do in a --with-ibm-db2 option. The point of using a Driver Manager though is to remove the headaches of using a different database on a per machine basis. But again absolutely nothing has changed between odbc_fetch_row functionality from 4.0.6 and 4.2.3, hence I'm wondering if it's a driver issue. Previous Comments: ------------------------------------------------------------------------ [2003-03-05 14:37:53] scott at abcoa dot com I'm not sure if I would want to try it. Seem that I would need to use the driver manager and the driver. It reminded me of OpenLink that became too much and I threw it out in the past. I like the idea of having PHP's ODBC to work with DB2 by using the '--with-ibm-db2' prefix because it give me fewer softwares to work with. I mean DB2 is not only database I had to deal with, but of some different database softwares as well as some for Windows. I mean no offense. I didn't really have that problem way back in the past. Maybe the problem will fix itself in the near future. Who know! ------------------------------------------------------------------------ [2003-03-04 10:36:43] kalowsky@php.net Any chance you can try building with unixODBC as the driver, and connecting via that? It seems to be the recommended means from IBM for connecting to DB2 systems. ------------------------------------------------------------------------ [2003-01-27 14:37:58] ranson at ea dot com I am having trouble with this as well, and have put in the bug workaround. It seeks to work but I have noticed that it skips my first row and duplicates my last row. ------------------------------------------------------------------------ [2002-10-02 12:06:17] kalowsky@php.net Updating summary ------------------------------------------------------------------------ [2002-09-27 12:16:06] scott at abcoa dot com I looked at few IBM books and IBM website and could find no such documentation about sql.log. I also tried typing in the command "find . -name '*log' -print" and got a few IBM DB2 logs but they aren't related to sql.log. Right now, I'm out of luck. Someone else will know more about it better than I do. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/19528 -- Edit this bug report at http://bugs.php.net/?id=19528&edit=1