|Keep It Simple, Stupid|
oracle DB connection from within a cgi-pageby Da_Mad_CoWw (Initiate)
|on Nov 02, 2004 at 14:06 UTC||Need Help??|
Da_Mad_CoWw has asked for the wisdom of the Perl Monks concerning the following question:
I'm having a strange problem with a cgi page I wrote.I think I know where the problem lies, but I'm getting a second opinion first :-)
Whenever I run the cgi from command-line the connection to the oracle db works fine.(listener runs at port 1521). Whenever I run the script from a browser ( http://mysite.domain.be/cgi-bin/script.cgi) , then I get the folowing message : ORA-12154: TNS:could not resolve service name (DBD ERROR: OCIServerAttach) I have a hunch that the problem lies with the fact that the listener runs at port 1521 and the webpage at port 80 and that it's the firewall who's giving me a hard time, but i'm not sure.
Anyone any suggestions?
thx in advance