RE: PHP 4.3.4, ADODB and Oracle9.2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux