Welcome Guest, Not a member yet? Register   Sign In
Oracle Connection
#1

[eluser]Unknown[/eluser]
Dear all,

I'm still newbie here and still in process of learning.
right now I'm working on a project. i'm stuck in oracle connection. I have already followed this topic http://ellislab.com/forums/viewthread/68453/.

————————————————————————————————————————-
File /system/application/config/database.php

//———————————————————————————————————————-
$dbhost = ‘192.168.0.15’; //IP of my host database
$dbport = ‘1521’; //Oracle port
$dbname= ‘MY_ORCL’; //My database Name

$dbConnString = “
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = “. $dbhost .”)(PORT = “. $dbport .”))
)
(CONNECT_DATA =
(SERVICE_NAME = “. $dbname .”)
))
“;
//————————————————————————————————————————

$active_group = “default”;

$db[‘default’][‘hostname’] = $dbConnString;
$db[‘default’][‘username’] = “MY_USER”;
$db[‘default’][‘password’] = “MY_PASSWORD”;
$db[‘default’][‘database’] = “”;
$db[‘default’][‘dbdriver’] = “oci8”;
$db[‘default’][‘dbprefix’] = “”;
$db[‘default’][‘active_r’] = TRUE;
$db[‘default’][‘pconnect’] = TRUE;
$db[‘default’][‘db_debug’] = TRUE;
$db[‘default’][‘cache_on’] = FALSE;
$db[‘default’][‘cachedir’] = “”;


but i get an error:

A PHP Error was encountered

Severity: Notice

Message: Use of undefined constant OCI_COMMIT_ON_SUCCESS - assumed 'OCI_COMMIT_ON_SUCCESS'

Filename: database/DB.php

Line Number: 133

------------------------------------------

I use codeigniter v 1.7.1 and wamp5 1.7.1


Could you guide me please, to make it right.

Thanks.
#2

[eluser]Serebrennikov N. Nick[/eluser]
your server doesn't support connecting to oracle.
php's module oci8* isn't enabled by default, so google "php oracle" or like that
#3

[eluser]Unknown[/eluser]
you are right,and i have already solved the problem.

Thanks




Theme © iAndrew 2016 - Forum software by © MyBB