Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Connect php to oracle

Re: Connect php to oracle

From: Matt <matthiar_at_gmx.net>
Date: Wed, 14 Jan 2004 21:32:07 -0500
Message-ID: <qJmdncVxRaU1ZpjdRVn-sA@pghconnect.com>


Tore Skogly wrote:
> Andy Hassall wrote:
>
>

>> Use single quotes.
>> 
>> In double quotes, \n turns into newline, \t turns into tab. You don't
>> want
>>this.
>>
>> Alternatively use / instead of \, as Windows will accept / as a directory
>>separator.
>>
>>
>>> $db="
>>> (DESCRIPTION =
>>>   (ADDRESS_LIST =
>>>       (ADDRESS =
>>>         (PROTOCOL = TCP)
>>>         (Host = <server ip>)
>>
>> Presumably this is not the real code.
>>
>>
>>>Connection Test
>>>Warning: ocilogon(): _oci_open_server: Error while trying to retrieve text
>>>for error ORA-12538 in c:\inetpub\wwwroot\oci8test.php on line 17
>>
>> 
>> Indicates ORACLE_HOME not set correctly, because of the \n \t confusion
>>earlier.
>>

>
>
> Thanks for your reply.
> I changed from double to single quotes, but with the same result.
> Unfortunately it didn't help me any further....
>
> I removed all environment settings from the php-page and tried to add a
> third parameter (the tnsnames.ora entry) to OCILogon().
> This resulted in the following output from my php page:
>
> =====================
> Connection Test
> Warning: ocilogon(): _oci_open_server: Error while trying to retrieve text
> for error ORA-12154 in c:\inetpub\wwwroot\oci8test.php on line 4
> Oracle Connect Error
> =====================
>
> As you notice the ORA error message changed from 12538 to 12154, but still
> no Oracle connection...
>

did you look into the nls_lang parameter? Received on Wed Jan 14 2004 - 20:32:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US