Can't Connect Codeigniter To Oracle in Frameworks Posted December 23, 2012 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!!!!!!!!!!
Can't Connect Codeigniter To Oracle
in Frameworks
Posted
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:
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:
Result:
yahooooooooo!!!!!!!!!!