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

ID: 19528 User updated by: scott at abcoa dot com Reported By: scott at abcoa dot com Status: Open Bug Type: ODBC related Operating System: AIX (UNIX) PHP Version: 4.2.2 New Comment: I was going to close this bug until I saw that there is 3 people out of 3 who are able to reproduce this problem. So, I decided to leave this open unless otherwise is closed by the developer at php.net because there are other people out there who are still struggling with this and are not as fortunate. The reason I'm going to close this bug is because I'm dumping IBM DB2 and make the move to Relexus Linter (DB software in Russia). It became appearant that it is a better software than IBM DB2 in many ways. Linter is smaller, use less maintainance, less headache, cost less, less problem with license, use less memory and work much faster on the same machine regardless of whether the table in the database is very large or not. Good Luck! Scott Previous Comments: ------------------------------------------------------------------------ [2003-03-11 08:49:39] scott at abcoa dot com Lost track of time, so sorry about that. What we're going to need is more people who are experiencing this problem. In answer to your question, I'm not sure if it is a driver issue or not because I have not upgraded the AIX nor have I upgraded the DB2 driver nor have I upgraded the DB2 software. I'm waiting for version 9.1 to come out and buy it, whew, it's a pretty expensive software. The only thing changes from that time of version 4.0.6 to 4.2.3 was the inclusion of the '--with-mcrypt' option to the configure command but this doesn't seem to be the cause of the problem because they are not related. We had one other user in this bug report who reported this problem. So, go ahead and put this bug in inactive status or something until someone can step forward with the problem. I don't have a solution to this problem. Thanks, Scott P.S. I have noticed that PHP have a built-in programming script that allow PHP to create a formatting and datas into a PDF then generate a PDF file. Maybe PHP developers can do that similar thing by coming up with some ideas to create a PHP Database or a PHP CVS file that can act as a database. The logic shouldn't be too difficult to come up with and it could help to depend less on the 3rd party database and instead more on the PHP. It is just an idea but not a bad idea... I would love to hear about it one day. ------------------------------------------------------------------------ [2003-03-10 20:41:10] sniper@php.net No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. ------------------------------------------------------------------------ [2003-03-05 16:38:52] kalowsky@php.net 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. ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ 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