Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Connect php to oracle
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. >>
Have you verified the environment variables ORACLE_HOME and ORACLE_SID are set correctly? Is the listener running? Is the service name correct? Have you verified the entries in tnsnames.ora?
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Thu Jan 08 2004 - 10:52:52 CST