DB2 -- Need help connecting to remote host/port/db dynamically?

[dt2002]

Hi,

I am currently converting from Oracle to DB2, and ran into a problem. With Oracle, I could connect to host/port/db dynamically using:

$host = 'remoteHost';
$port = '9999';
$dbName = 'myDb';
$username = 'myname';
$password = 'mypassword';

$tns = "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = " . $host . ") (PORT = " . $port . ")) (CONNECT_DATA = (SERVICE_NAME = " . $dbName . ")))";

$dbConn = OCIPLogon($username, $password, $tns);

How can this be done with DB2?
I understand that for DB2, we use odbc_pconnect(),
but how can I specify the host/port/dbName dynamically?

Thanks in advance.

--David.

[barand]

The odbc driver for your db2 database will let you specify all you need for your connection when you create the odbc dns via the odbc control panel.

Having created the odbc dns with a name of, say, db2database, you specify that name in the connection function

$db2cnx = odbc_connect("db2database","user","password");

HTH

[dt2002]

Hi Barand,

Thanks for the reply. I understand how to connect
using:
odbc_pconnect ( string dsn, string user, string password [, int cursor_type])

when the dsn has already been manually defined. However,
I want to know how to connect to a remote host/port/db
when the host/port/db information available only during
runtime. i.e., not by setting up a local db alias using the
DB2 Client. (I said DB2 Client because according to the
documentation in php.net, connection to DB2 does not
involve ODBC even though the PHP command is odbc_pconnect.)

So do you know of a way to specify remote host/port/db
during runtime? Thanks in advance.

[barand]

I've searched for solutions but all use either ODBC or ADO via OLEDB.

I can think of 2 possible solutions

• a predefined odbc dsn for each possible connection

  write a php_db2.dll (that is probably going to start a new thread on "How to...")