Can't Connect Codeigniter To Oracle

[zalexy]

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

[Sanjib Sinha]

CodeIgniter always allows you to use libraries folder to put your own php code so that you can later use them.

 

So create a php file like Oracleconnect.php in your libraries. Put your code there and access the function like this:

 

Suppose, you have created a class in your OracleConnect.php

 

class Oracleconnect {
public function __construct() {

}

public function functionName() {
 $conn = oci_connect("xxxxxx", "xxxxxx","");
 if (!$conn) {
	 echo "Not connected!";
 }
 else
	 echo "yahooooooooo!!!!!!!!!!";
}

 

Now in your controller, call that library file:

 

//a function to load library and passing values to views
 public function getconnect() {
	 $this->load->library('oracleconnect');

	 $data['output']= $this->oracleconnect->functionName();

	 $this->load->view('main', $data);
 }

 

In your view (suppose that is main.php) you will get the output, you wanted.

Edited January 3, 2013 by Sanjib Sinha