Differences

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

--- v5:database:ibm_db2 [2023/01/24 03:53] – mnewnham
+++ v5:database:ibm_db2 [2026/02/15 03:00] (current) – mnewnham
@@ Line 19: / Line 19: @@
 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 and 8 drivers for windows are currently available [[https://github.com/ibmdb/php_ibm_db2|here]]
+PHP 8.5 and lower drivers for Windows are currently available [[https://pecl.php.net/package/ibm_db2|here]]
 ----------------------------------
@@ Line 70: / Line 70: @@
 $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>
@@ Line 103: / Line 120: @@
 </WRAP>
 This driver provides undocumented bind variable mapping from ibm to oracle.The functionality appears to overlap the db2_oci driver
-{{tag>[ibm db2 tier1]}}
+{{tag>ibm db2 tier1}}
 ===== Case Sensitivity In Table And Column Names =====
@@ Line 137: / Line 154: @@
-{{tag>[db2 supported]}}
+{{tag>db2 supported}}