problem with configure PHP with IBM-DB2 driver for connecting Apache derby database

**Dormilich** · Feb 19 '10, 05:22 AM

how do you connect to the DB?

**Markus** · Feb 19 '10, 03:45 PM

Please see this page on php.net.

**knellim** · Feb 19 '10, 06:13 PM

I connect to the DB using the CATALOG TCPIP command. My database is located on the same machine.
I start the Derby Network serveri in Opt/Apache/derby/bin by giving
# ./startNetworkser ver&

The database created is named as vcl
Then, I start the DB2 CLI and give the below commands
db2=>catalog tcpip node vclnode remote localhost server 1527
db2=>catalog db VCL at node vclnode authetication server
db2=>connect to VCL user vcluser using vclPassw

This connectd my DB2 client and derby database as I can see tables by giving select command,

Can u help me in connecting PHP with DB2. Thanks....in advance

**Markus** · Feb 19 '10, 06:16 PM

Originally posted by knellim

I connect to the DB using the CATALOG TCPIP command. My database is located on the same machine.
I start the Derby Network serveri in Opt/Apache/derby/bin by giving
# ./startNetworkser ver&

The database created is named as vcl
Then, I start the DB2 CLI and give the below commands
db2=>catalog tcpip node vclnode remote localhost server 1527
db2=>catalog db VCL at node vclnode authetication server
db2=>connect to VCL user vcluser using vclPassw

This connectd my DB2 client and derby database as I can see tables by giving select command,

Can u help me in connecting PHP with DB2. Thanks....in advance

Did you see my reply?

**knellim** · Feb 19 '10, 07:28 PM

I only saw ur last reply asking me how I connect to DB.. I did answer that and i m waiting fr ur resonse...

**Markus** · Feb 19 '10, 07:36 PM

That wasn't my reply. See #3.

**knellim** · Feb 19 '10, 07:39 PM

oh yaa..i saw that.. I am following the steps now.. I will try it and tell u if thagt worked..

**knellim** · Feb 19 '10, 10:22 PM

Hi Marcus,

I have the ibm_db2 driver configured. I made the changes to php.ini file as
extension=pdo.s o
extension=ibm_d b2.so
ibm_db2.instanc e_name=knellim

I have written php file in /var/www/html as

Code:

<?php
// Create the uncataloged connection string
 $DSN = "DRIVER={IBM DB2 ODBC DRIVER};PROTOCOL=TCPIP;"
         . "DATABASE='TEST';HOSTNAME='localhost';PORT=1527;"
         . "UID='knellim';PWD='db2';";
$conn = db2_connect($DSN,null,null);
$sql = "SELECT id FROM resource";
$stmt = db2_prepare($conn, $sql);
$res = db2_execute($stmt, array(10));
while ($row = db2_fetch_assoc($res)) {
print "{$row['id']}\n";
}
?>

and when i run it I as php connect.php , I get

PHP Warning: db2_prepare() expects parameter 1 to be resource, boolean given in /var/www/html/testvcl.php on line 9
PHP Warning: db2_execute() expects parameter 1 to be resource, null given in /var/www/html/testvcl.php on line 10
PHP Warning: db2_fetch_assoc () expects parameter 1 to be resource, null given in /var/www/html/testvcl.php on line 11

Pls can u help me with this.. Any idea why this is happening..??

**knellim** · Feb 19 '10, 10:45 PM

PHP connection failing to Derby db

I wrote a simple script for testing my connection

Code:

<?php

$database = 'VCL';
$user = 'vcluser';
$password = 'vcluserpassword';

$conn = db2_connect($database, $user, $password);

if ($conn) {
    echo "Connection succeeded.";
    db2_close($conn);
}
else {
    echo "Connection failed.";
}
?>

It says Connection failed

Whats the username and password to be given there.. Is it the database user name and passw or DB2 instance username and password??

Please suggest

**Dormilich** · Feb 19 '10, 10:46 PM

you simple fail to connect, so db2_connect() returns false. have you tried PDO, you installed the PDO driver after all?

**Dormilich** · Feb 19 '10, 10:49 PM

Whats the username and password to be given there.. Is it the database user name and passw or DB2 instance username and password??

like the manual says, the login/password of the DB.

**knellim** · Feb 19 '10, 10:55 PM

Yes , I do have the pdo driver
I did php -m and it shows me the PHP modules which has the PDO

**Dormilich** · Feb 19 '10, 10:59 PM

you could try to connect to DB2 using PDO.

**knellim** · Feb 19 '10, 11:07 PM

How can I do that.. Can u give me any example

problem with configure PHP with IBM-DB2 driver for connecting Apache derby database

problem with configure PHP with IBM-DB2 driver for connecting Apache derby database

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment