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