selecting from db2 with php error

SimonJ621 · #1 (**permalink**) 08-15-07, 18:31

I am trying to select from a DB2 database with PHP. To my knowledge, the connection is being made, but the select statement won't run. The following is the error I receive:

Quote:

Warning: odbc_exec() [function.odbc-exec]: SQL error: [IBM][CLI Driver][DB2/AIX64] SQL0644N Invalid value specified for keyword "CONCURRENCY" in statement "<ATTRIBUTE-STRING>". SQLSTATE=42615 , SQL state 42615 in SQLExecDirect in C:\wamp\www\db.php on line 24

I can't find much help online, which is why I am posting here. Any help would be much appreciated as I have never attempted to use DB2. Following is my PHP code:

PHP Code:


			
<?php 







function dbconnect($verbose) {



    $dbname = "**";



    $username = "**";



    $password = "**";



    



    $dbconn = odbc_pconnect($dbname, $username, $password);



    



    if (($verbose == TRUE) && ($dbconn == 0 )) {



        echo("connection to database failed.");



        $sqlerror = odbc_errormsg($dbconn);



        echo  "<br /><br />".$sqlerror."<br /><br />";



    }



    



    return($dbconn);



}











function display($dbconn) {



    $select_stmt = "SELECT * FROM blabla";







    if ($dbconn != 0) {



        $result = odbc_exec($dbconn, $select_stmt);



        if ($result == 0) {



            echo "SELECT statement failed.<br />";



            $sqlerror = odbc_errormsg($dbconn);



        }



        else {



            odbc_result_all($result);



        }



    }



}







$verbose = TRUE;



$dbconn = dbconnect($verbose);







display($dbconn);











?>

Thank you for all the help,

Jason
__________________
------------------------------------
http://www.elefoo.com
http://www.blackspyraldancer.com

stolze · #2 (**permalink**) 08-16-07, 04:45

Don't use the PHP ODBC driver. It is very buggy.

There is a DB2-specific PHP driver available, which is also supported by the DB2 development team.

SimonJ621 · #3 (**permalink**) 08-17-07, 08:17

Thanks Stolze,

I used db2_connect and it worked fine. The following code worked:

PHP Code:


			
$conn = db2_connect($dbname, $username, $password);

if ($conn) {
   $sql = "SELECT * FROM Table1";
   $stmt = db2_prepare($con, $sql);
   db2_execute($stmt);

   $rows = array();
   $i = 0;

   while (db2_fetch_row($stmt)) {
      $rows[$i] = db2_result($stmt, 0);
      echo $rows[$i]."<br />";
      $i++;
   }
}
else {
   echo "Connection failed. <br />";
   echo db2_conn_errormsg();
}