Welcome Guest, Not a member yet? Register   Sign In
how to connect to oracle oci 8
#1

[eluser]Unknown[/eluser]
HI everybody.

I have been using CI with mysql for as long as 6 months,
now i want to connect with oracle 10g
Can anybody please help me to connect to oracle database.
I want to use SCOTT/TIGER@orcl tables to access.
#2

[eluser]411161[/eluser]
Here is my database.php Notice what I commented out. One of those statements cause me not to be able to connect. I believe the db_debug was the culprit. But then I would conenct but

$db['default']['hostname'] = "localhost";
$db['default']['username'] = "as411161";
$db['default']['password'] = "as411161";
$db['default']['database'] = "vcpdb";
$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";
*/

I do see posts out there like this one:
http://ellislab.com/forums/viewthread/63301/
#3

[eluser]Unknown[/eluser]
I use this configurations :
$db['default']['hostname'] = "//127.0.0.1/ORCL";
$db['default']['username'] = "SCOTT";
$db['default']['password'] = "TIGER";
$db['default']['database'] = "ORCL";
$db['default']['dbdriver'] = "oci8";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = FALSE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";




Theme © iAndrew 2016 - Forum software by © MyBB