From: dlincke@bandon.unisg.ch (David-Michael Lincke)
Subject: Re: Access Oracle from CGI?  How?
Date: 1995/10/10
Message-ID: <1995Oct10.165220.3582@sgcl1.unisg.ch>#1/1
references: <00001a1b+00003464@msn.com>
organization: Institute for Information Management at USG
newsgroups: comp.databases.oracle


Eric Karabin (Eric_Karabin@msn.com) wrote:

> I can connect to Oracle in a simple Pro*C program on my SGI INDY, but 
> when I try to do it in as a CGI program, I get the error:
> ORA-12545: Unable to open message file (SQL-02113).
 
> Why does it fail as a CGI program?
> Even if I change my Netscape server user from Nobody to my own name, 
> it gives the same error.

Most likey you haven't set up a correct environment. Be sure to do the
following before EXEC SQL CONNECT:

putenv("ORACLE_HOME=/my/oracle_home");

putenv("TWO_TASK=connectstring");
or
putenv("ORACLE_SID=mySID";
depending on if you are connecting locally or remote.

dave
--
David-Michael Lincke	Institute for Information Management at USG
EMail: dlincke@sgcl1.unisg.ch
URL: http://www-iwi.unisg.ch/about/team/dal.html