Re: Connect php to oracle

From: Tore Skogly <tore.skogly_at_no.spam.invalid>
Date: Thu, 08 Jan 2004 17:16:58 +0100
Message-ID: <1073578617.52259@gurney>

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...

-- 
Regards, 
Tore Skogly

Received on Thu Jan 08 2004 - 10:16:58 CST