Jump to content

zalexy

New Members
  • Posts

    1
  • Joined

  • Last visited

Posts posted by zalexy

  1. Please help! i can't connect codeigniter to Oracle

    I am trying to connect Codeigniter to Oracle 11g, here are my settings

     

     

    Settings in database.php:

    $active_group = 'default';
       $active_record = TRUE;
       $db['default']['hostname'] = "//localhost/";
       $db['default']['username'] = 'xxxxxxx';
       $db['default']['password'] = 'xxxxxxx';
       $db['default']['database'] = 'orcl';
       $db['default']['dbdriver'] = 'oci8';
       $db['default']['dbprefix'] = '';
       $db['default']['pconnect'] = TRUE;
       $db['default']['db_debug'] = TRUE;
       $db['default']['cache_on'] = FALSE;
       $db['default']['cachedir'] = '';
       $db['default']['char_set'] = 'utf8';
       $db['default']['dbcollat'] = 'utf8_general_ci';
       $db['default']['swap_pre'] = '';
       $db['default']['autoinit'] = TRUE;
       $db['default']['stricton'] = FALSE;
    

     

     

    Note: I added the C:\instantclient_11_2 to environment variable to PATH.

     

    Oracle :

    oracle port number: 1521

    oracle hostname: Home-pc

    database name: orcl

     

     

    Only when I run my CodeIgniter login code it shows this error message:

     

    A Database Error Occurred

     

    Unable to connect to your database server using the provided settings.

     

    Filename: D:\xampp\htdocs\ci\system\database\DB_driver.php

     

    Line Number: 124

     

    But I can connect to Oracle when I run a simple php code like:

     

    <?php
       $conn = oci_connect("xxxxxx", "xxxxxx","");
       if (!$conn) { 
          echo "Not connected!";
       }
       else
         echo "yahooooooooo!!!!!!!!!!";
       ?>
    

    Result:

    yahooooooooo!!!!!!!!!!

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.