Re: FastCGI with Oracle

Thank you libo (I am not sure about the name, since it shows in chinese
language)



The solution which you gave has helped me.  But its not after accept its
before that. we need to set it back in the C++ program.  I used the setenv
function in c++ and now its connecting to oracle.



Thanks for the timely reply.



Arun

  _____

From: 李波 [mailto:[email protected]]
Sent: Thursday, December 03, 2009 7:37 AM
To: A. M. ArunKumar
Subject: Re: [FASTCGI] FastCGI with Oracle



ha ha , i know the answer, ^_^



you should set oracle env at c++ source code after Accept() .because all env
will be cleared after Accept()











2009/12/2 A. M. ArunKumar <arun-66HqTtf422AmlAP/[email protected]>

Hi,



I am new to this FastCGI.  I have an issue in connecting to Oracle database
through fast CGI using my C++ program.  I get the error as “Cannot Create
OCI Environment”  The same program works fine without fast CGI.  The issue
happens to be only in FastCGI.



I defined the following SetEnvs to work in cgi-bin



<Location "/cgi-bin/">

  SetEnv ORACLE_BASE "/app/oracle"

  SetEnv ORACLE_HOME "/app/oracle/product/10.2.0/db_1"

  SetEnv ORACLE_SID "DEVPORC1"

  SetEnv OCILIB_INC "/usr/local/include"

  SetEnv OCILIB_LIB "/usr/local/lib"

  SetEnv LD_LIBRARY_PATH "/app/oracle/product/10.2.0/db_1"

</Location>





If I do the same thing for fcgi-bin its not working.



Thanks

Arun




_______________________________________________
FastCGI-developers mailing list
FastCGI-developers-xGejAJT2w6xVgU18Zptdi0EOCMrvLtNR@public.gmane.org
http://mailman.pins.net/mailman/listinfo.cgi/fastcgi-developers

_______________________________________________
FastCGI-developers mailing list
FastCGI-developers-xGejAJT2w6xVgU18Zptdi0EOCMrvLtNR@public.gmane.org
http://mailman.pins.net/mailman/listinfo.cgi/fastcgi-developers