On Mon, 17 Jun 2002 00:30:52 -0400 Roger Patrick <[EMAIL PROTECTED]> wrote:
> I have a novice cgi script that connects to a database and retrieves > some data. When I run the script from the command line, I receive the > correct results. However, from the web I receive the following error: > > DBI->connect(ORACLE) failed: Error while trying to retrieve text for > error ORA-12154 (DBD ERROR: OCIServerAttach) at /www/site/cgi-bin/db.cgi > line 10. The ORA-12xxx series messages normally involve name resolution or network communications problems. The failure to retreive text means that the file containing the text wasn't where it was expected. Both are probably the result of not having ORACLE_HOME set correctly in the webserver's environment. You will have to consult your webserver's documentation to see how to set it. Depending on the operating system, you may also need to set several other environment variables as well. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.