Differences

This shows you the differences between two versions of the page.

--- v5:database:ibm_db2 [2020/01/13 12:37] – Add tier1 tag dregad
+++ v5:database:ibm_db2 [2024/05/25 04:30] (current) – [Connection Example Using DSN] mnewnham
@@ Line 13: / Line 13: @@
 == Alternative Drivers ==
 [[v5:database:odbc#odbc_db2|ODBC Driver For IBM DB2]]\\
+== See Also ==
+[[v5:reference:connection:setconnectionparameter#ibmdb2|setConnectionParameter()]]
 </WRAP>
 ===== Description =====
 This driver provides a connection to IBM DB2 Databases, using the IBM Data Client. This driver replaces the original [[v5:database:odbc#odbc_db2|DB2 ODBC]] driver.
 == PHP Drivers For Windows ==
-PHP 7 drivers for windows are currently available [[https://github.com/ibmdb/php_ibm_db2|here]]
+PHP 7 and 8 drivers for windows are currently available [[https://github.com/ibmdb/php_ibm_db2|here]]
 ----------------------------------
@@ Line 45: / Line 47: @@
 The DB2 database must be catalogued for a connection like this to work.
 </WRAP>
+==== Building a catalog entry ====
+This is a simple example building a catalogued connection from a windows client to a remote DB2 server running on a machine named adodb-db2.local. The server is running on port 25010. We will add a DSN entry called //**adodb-test**//
+<code>
+db2cli writecfg add -database SAMPLE -host adodb-db2.local -port 25010
+db2cli writecfg add -dsn adodb-test -database SAMPLE -host adodb-db2.local -port 25010
+</code>
+To use this DSN
 <code php>
 include '../adodb/adodb.inc.php';
-$database = 'SAMPLE';
+$dsn = 'adodb-test';
 $user = 'db2inst1';
 $password = 'instance';
 $conn = ADOnewConnection('db2');
-$conn->connect($database, $user, $password);
+$conn->connect($dsn, $user, $password);
 </code>
@@ Line 57: / Line 67: @@
 <code php>
 include '../adodb/adodb.inc.php';
-$dsn = 'hostname=192.168.0.30;protocol=tcpip;port=50000;database=SAMPLE;uid=db2inst1;pwd=instance';
+$dsn = 'hostname=adodb-db2.local;protocol=tcpip;port=25010;database=SAMPLE;uid=db2inst1;pwd=instance';
 $conn = ADOnewConnection('db2');
 $conn->connect($dsn);
+</code>
+------------------------------
+===== Connection Example Using *LOCAL =====
+<code php>
+include '../adodb/adodb.inc.php';
+$dsn = 'hostname=adodb-db2.local;protocol=tcpip;port=25010;database=SAMPLE;uid=db2inst1;pwd=instance';
+$conn = ADOnewConnection('db2');
+$conn->connect($dsn);
+/*
+* Add another connection
+*/
+$dsn = '*LOCAL';
+$conn2 = ADOnewConnection('db2');
+$conn2->connect($dsn);
+------------------------------
 </code>