0

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 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!!!!!!!!!!

2
Contributors
2
Replies
3
Views
4 Years
Discussion Span
Last Post by zalexy
0

As already suggested elsewhere change:

$db['default']['hostname'] = "//localhost/";

to:

$db['default']['hostname'] = "localhost";

bye.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.