TNS error

View: New views

2 Messages — Rating Filter: Alert me

TNS error

by Mekhael, Rezk :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

I am getting this error when I am using zend/php to connect to database – where is the tnsname.ora located in Zend configuration files – under what directory – and it is in OS env level or Zend web/apache level?

ORA-12154: TNS:could not resolve the connect identifier specified

PS: I can use the command sqlplus to connect to the database but not the php.

Sincerely,

Rezk Mekhael

Re: TNS error

by Justin Plock :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Mekhael, Rezk wrote:

> I am getting this error when I am using zend/php to connect to database
> – where is the tnsname.ora located in Zend configuration files – under
> what directory – and it is in OS env level or Zend web/apache level?
>
>
>
> ORA-12154: TNS:could not resolve the connect identifier specified
>
>
>
>
>
> PS: I can use the command sqlplus to connect to the database but not the
> php.
>
>
>
>
>
>
>
> Sincerely,
>
> Rezk Mekhael
>

Hi,
The TNS entry is generated in either the OCI or PDO_OCI Zend_DB
adapters. Make sure you are specifying the host and the port in your
connection parameter array.

-Justin

LightInTheBox - Buy quality products at wholesale price