Advertisement
Guest User

Untitled

a guest
Apr 20th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. <?php
  2. $database = 'mydb';
  3. $user = 'usr';
  4. $password = 'pass';
  5. $hostname = 'ipaddr';
  6. $port = 9501;
  7.  
  8. $conn_string = "DRIVER={IBM DB2 ODBC DRIVER};DATABASE=$database;" . "HOSTNAME=$hostname;PORT=$port;PROTOCOL=TCPIP;UID=$user;PWD=$password;";
  9. $conn = db2_connect($conn_string, '', '');
  10.  
  11. if ($conn) {
  12. echo "Connection succeeded.";
  13. db2_close($conn);
  14. }
  15. else {
  16. echo db2_conn_error();
  17. echo db2_conn_errormsg();
  18. }
  19.  
  20. extension = / usr/lib64/php/modules/ibm_db2.so
  21. ibm_db2.instance_name = db2inst1
  22.  
  23. #for DB2
  24. . /opt/ibm/db2/V10.5/cfg/db2profile
  25.  
  26. useradd db2inst1
  27.  
  28. /opt/ibm/db2/V11.1/instance/db2icrt db2inst1
  29.  
  30. extension=/usr/lib64/php/modules/ibm_db2.so
  31. ibm_db2.instance_name=db2inst1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement