Re: CGI with Oracle and pro*c

In article <31031d52.60ac5168_at_usw-ex0102-084.remarq.com>,   LM <lauram3017NOlaSPAM_at_aol.com.invalid> wrote:
> I wrote a C program using pro*c to access Oracle for use as a CGI
> program. It works fine on Windows with Apache. I tried it on
> an AIX machine using pro*c for 8.1.5. It works fine if I run it
> stand-alone via telnet, but when I try to run it via a web
> browser using Apache on the AIX machine, I get error ORA-12154.
> Does anyone have any idea how to get this working?
>

your environment in the cgi-bin is set wrong. Most likely, the oracle_home is wrong or invalid (it cannot find the tnsnames.ora file and hence the 12154, cannot resolve service name error).

Use apaches passenv/setenv directives in the webserver to get the right environment going.

> Thanks.
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion
 Network *
> The fastest and easiest way to search and participate in Usenet -
 Free!
>
>

--
Thomas Kyte                              tkyte_at_us.oracle.com
Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.