Hi All, 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" Now originally I was getting the following Oracle error: Warning (2): oci_connect() [function.oci-connect]: ORA-12154: TNS:could not resolve the connect identifier specified [CORE\cake\libs \model\datasources\dbo\dbo_oracle.php, line 144] I located somewhere on the web that it says I should use 'database' => '//localhost/oradbname'. When I make the change to the database.php file I get the following error: Warning (2): oci_connect() [function.oci-connect]: ORA-12705: Cannot access NLS data files or invalid environment specified [CORE\cake\libs \model\datasources\dbo\dbo_oracle.php, line 144] Now this says it has something to do with my NLS_LANG variable which is set (see above). I also set the 9i ORA_NLS33 to point to the right NLS data location. So basically it is still not working and I am not sure which error is further ahead in my connectivity with my oracle database. Anybody been able to get a 9i database to work with PHP 5.2.4 using CakePHP 1.2? Sincerely, Kristopher --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
