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@xxxxxxxxxx] Sent: January 19, 2004 12:14 AM To: william@xxxxxxxxxxxx Cc: php-db@xxxxxxxxxxxxx Subject: Re: 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