dude
dude

Reputation: 4982

How to connect to oracle db by using only host url in codeigniter

I have open port url 192.168.1.9 and its username : test and password: test of a oracle database How can i connect to the oracle database using this data and url in codeigniter?

Upvotes: 4

Views: 2103

Answers (1)

tereško
tereško

Reputation: 58454

To do it you will have to use oci8 extension with CI`s oci8 driver:

$config['hostname'] = '192.168.1.9/XE'; // assuming it is XE
$config['username'] = 'test';
$config['password'] = 'test';
$config['database'] = 'dbname';
$config['dbdriver'] = 'oci8';

This _should_ work.

If you hoped to use PDO for it, then it is not possible. Mostly because of pdo_oci driver's strangeness and disaster, that is CI's database drivers.

Upvotes: 2

Related Questions