Hi All,

I am getting the following error:
ocilogon(): _oci_open_server: Error while trying to retrieve text for error ORA-12538

My environment is:
OS: Windows 2000
DB: Oracle 9.2
using php 4.3.10

database Server and IIS or on the same machine. I have done manual installation of php and it looks correct to me.

my question is do i need to setup 'ORACLE_HOME and TNS_ADMIN vars in windows as well..........
if I do need to do so what are the my best options.
Thanks.
Najm

    Yes, you need ORACLE_HOME and ORACLE_SID. You should be able to get away with setting them using [man]putenv[/man].

    <?php
putenv('ORACLE_HOME=C:\\ora8\\product\\8.1.7');
putenv('ORACLE_SID=ora8i');

/* rest of script */

    See if doing that helps...

      Thank you very much for your reply. However it did not help me.
      here is snips of code that i am using to connect:
      echo "<pre>";
      putenv('ORACLE_HOME=D:\oracle\ora92');
      putenv('ORACLE_SID=oradb2');

      $db = "oradb2";

      $c1 = ocilogon("scott", "tiger", $db) or die("Could not connet");
      $c2 = ocilogon("scott", "tiger", $db)or die("Could not connet");

      my both oracle 9.2.0.2 and php are in windows environment.

      Thanks in advance for all your help

      Regards,
      Najm

        Write a Reply...