Re: Access Oracle from CGI? How?

Eric Karabin (Eric_Karabin_at_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_at_sgcl1.unisg.ch
URL: http://www-iwi.unisg.ch/about/team/dal.html