Welcome Guest, Not a member yet? Register   Sign In
[SOLVED]CodeIgniter and Oracle 11
#1

[eluser]Mareshal[/eluser]
trying to make CI play with Oracle...but

Code:
$db['default']['hostname'] = "//localhost:1521/oracleServer"; //SID is oracleServer, not XE, so is correct
$db['default']['username'] = "SYSTEM";
$db['default']['password'] = "oracle";
$db['default']['database'] = "TEST";
$db['default']['dbdriver'] = "oci8";

These settings work from SQL Plus or SQL Developer, user SYSTEM is ok, but is CI 2.0 I get


Code:
A Database Error Occurred

Unable to connect to your database server using the provided settings.
#2

[eluser]Mareshal[/eluser]
Code:
$db['default']['hostname'] = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=oracleServer)))';

Solution found!




Theme © iAndrew 2016 - Forum software by © MyBB