RE: [PHP-DB] PHP 4.3.4, ADODB and Oracle9.2

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:Christopher.Jones@oracle.com] Sent: January 19, 2004 12:14 AM To: william@databyte.com Cc: php-db@lists.php.net 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