Advertisement
Guest User

Untitled

a guest
Sep 22nd, 2016
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. $db['default'] = array(
  2. 'dsn' => 'oci:dbname = (DESCRIPTION =
  3. (ADDRESS_LIST =
  4. (ADDRESS = (PROTOCOL = TCP)(HOST = Server ip)(PORT = Server port))
  5. )
  6. (CONNECT_DATA =
  7. (SERVICE_NAME = project)
  8. )
  9. )',
  10. 'hostname' => 'Server ip',
  11. 'username' => 'exampg',
  12. 'password' => 'Server pw',
  13. 'database' => 'project_exampg',
  14. 'dbdriver' => 'pdo');
  15.  
  16. SQLSTATE[HY000]: pdo_oci_handle_factory: ORA-12560: TNS:protocol adapter error
  17.  
  18. $tns = "(DESCRIPTION =
  19. (ADDRESS_LIST =
  20. (ADDRESS = (PROTOCOL = TCP)(HOST = Server IP)(PORT = Server port))
  21. )
  22. (CONNECT_DATA =
  23. (SERVICE_NAME = project)
  24. ))";
  25. $db_username = "exampg";
  26. $db_password = "server pw";
  27. try{
  28. $db = new PDO("oci:dbname=".$tns,$db_username,$db_password);
  29. }catch(PDOException $e){
  30. echo ($e->getMessage());
  31. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement