Thanks,
I found out that the TNS name in ADODB is wrong. After I fixed it, the error
gone.
William Cheung B.Sc, MCSE, MCDBA
Databyte Corp.
-Original Message-
From: Christopher Jones [mailto:[EMAIL PROTECTED]
Sent: January 19, 2004 12:14 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PHP 4.3.4, ADODB and Oracle9.2
William Cheung wrote:
Win 2K server
IIS 4.0
PHP 4.3.4
ADODB 4.10
Oracle 9.2
I got the following error
Warning: ociplogon():_oci_open_server: Error while trying to retrieve
text for error ORA-12538 in C:\PHPRoot\ADODB\drivers\adodb-oci8.inc.php
on line 128
You might be hitting a combination of problems.
I noticed the message Error while trying to retrieve text. This
means that your ORACLE_HOME is not set properly somewhere, and after
the ORA-12538 occurs Oracle can't look up actual text for it. Other,
more important things are likely to fail if the environment is not set
properly.
There's a note about the environment variables and Apache in the
Oracle/PHP troubleshooting FAQ:
http://otn.oracle.com/tech/opensource/php/php_troubleshooting_faq.html#envva
rs
It might give some background that applies to IIS too.
As to why the ORA error occurs - I'm not sure yet. I've seen
ORA-12538 with ADOdb 4.10 in scripts that work with ADOdb 3.60. See
http://phplens.com/lens/lensforum/msgs.php?id=8330
Chris
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.560 / Virus Database: 352 - Release Date: 1/08/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.560 / Virus Database: 352 - Release Date: 1/08/2004
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php