Re: PHP + Oracle

Frerotte Cyrille wrote:
>
> I don't know how to use PHP functions to access to a remote database from my
> Apache web server with PHP. When I use OCILogon or Ora_Logon, I can't
> connect to the database.
> I don't have oracle on my web server, only the net8 librairies.
>
> I hear about the file "tnsnames.ora" but i can't find on the web any
> documentation in order to configure this with PHP.
>
> Anyone can help me?

Can you connect to the db from sqlplus (I only use Oracle 7 .... but I presume 8 has a similar cmdline sql tool?) on the webserver? Have you tried setting the relevant environment variables in your script?

eg

putenv("ORACLE_HOME=<wherever>");
putenv("ORACLE_SID=<whatever>");

(again I'm quoting for oracle 7... hope it's of some use)

-- 
Dan Hopkins