From: Thomas J. Kyte Subject: Re: CGI with Oracle and pro*c Date: 2000/03/03 Message-ID: <89n0uh$e4r$1@nnrp1.deja.com>#1/1 References: <31031d52.60ac5168@usw-ex0102-084.remarq.com> To: lauram3017la@aol.com X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT) X-Http-Proxy: 1.0 x23.deja.com:80 (Squid/1.1.22) for client 205.227.43.13 Organization: Deja.com - Before you buy. X-Article-Creation-Date: Fri Mar 03 00:28:05 2000 GMT X-MyDeja-Info: XMYDJUIDtkyte Newsgroups: comp.databases.oracle.server In article <31031d52.60ac5168@usw-ex0102-084.remarq.com>, LM 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@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.