2007/10/15, Kristopher <[EMAIL PROTECTED]>:
> I have been struggling to get CakePHP to communicate with an Oracle 9i
> database. I have installed the 10g Instant Client and have created a
> batch file to run my Apache 2.2 server. In this batch file I have set
> the following environnment variables:
>
> set ORACLE_BASE="D:\oracle"
> set ORACLE_HOME="%ORACLE_BASE%\ora92"
> set ORA_NLS="%ORACLE_HOME%\ocommon\nls\admin\data"
> set ORA_NLS33="%ORACLE_HOME%\ocommon\nls\admin\data"
> set NLS_LANG="UTF8"
The Instant Client does not require you to have any ORACLE_* or NLS_*
environment variables.
Try the 10g's Easy Connect syntax:
class DATABASE_CONFIG {
var $default = array(
'driver' => 'oracle',
'persistent' => false,
'connect' => 'oci_connect',
'host' => '',
'login' => 'user',
'password' => 'password',
'database' => 'hostname:port/serviceName',
'prefix' => ''
);
}
Regards,
Martin
--
Martin Schapendonk, [EMAIL PROTECTED]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
