Differences

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

--- v5:database:pdo [2019/01/06 04:22] – mnewnham
+++ v5:database:pdo [2019/12/27 02:10] – [pdo_oci] mnewnham
@@ Line 25: / Line 25: @@
 $user     = 'pdo-user';
 $password = 'pdo-pass';
-$dsnString= 'host=localhost;dbname=employees;charset=utf8mb4'
+$dsnString= 'host=localhost;dbname=employees;charset=utf8mb4';
 $db->connect('mysql:' . $dsnString,$user,$password);
@@ Line 86: / Line 86: @@
 ----------------------------------------------
 ==== pdo_oci ====
 <WRAP right box round 300px>
 == Preferred Driver ==
@@ Line 92: / Line 94: @@
 ^Driver Name|pdo|
 ^Data Provider|pdo|
-^Status|Inactive((This driver is not supported by ADOdb project members, but you can contribute to this driver if you have the expertise))|
+^Status|Active((This driver is supported by ADOdb project members)|
 ^Windows|Yes|
-^Unix|No|
+^Unix|Yes|
 ^ADOdb V5|Yes|
 ^ADOdb V6|Yes|
 </WRAP>
-The current status of this driver is unknown
+== Limitations ==
+ - There id no support for the complex binding features available in the Native Driver
+ - Some MetaFunctions are unavailable
+----------------------------------------
+=== Sample Connection String ===
+If you are using the instantclient, and there is no tsnames.ora defined, you can define a connection like this
+<code php>
+//Connecting to Oracle Express on 192.168.86.86
+$tns = "
+(DESCRIPTION =
+    (ADDRESS_LIST =
+      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.86.86)(PORT = 1521))
+    )
+    (CONNECT_DATA =
+      (SERVICE_NAME = XEPDB1)
+    )
+  )
+";
+$dsnString="oci:dbname=$tns";
+$db->connect($dsnString,$userName,$password);
+</code>
 ------------------------------------------
 ==== pdo_pgsql ====