Oracle support in PHP?

[Ryan Schmidt]

On Dec 16, 2007, at 16:33, John Korchok wrote:

> The Instant Client still requires an environment variable TNS_NAMES  
> to point
> to the sqlnet.ora and tnsnames.ora files. The files allow abbreviated
> connection strings. For some reason, I was not able to set a  
> TNS_NAMES that
> the Instant Client would read (I tried setting it in the current user
> '.profile', in 'opt/local/apache2/bin/envvars' to get the Apache  
> user and
> finally '/private/etc/profile' to make it system-wide. Nothing  
> worked, the
> Instant Client gives every appearance of not reading TNS_NAMES at  
> all. I
> finally gave up and set verbose connection strings:
>
> $con = oci_connect('yourusername', 'yourpassword',
> '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=serverurloripaddress) 
> (PORT=portnu
> mber))(CONNECT_DATA=(SID=servicename)(SERVER=DEDICATED)))');
>
> It works! Macports PHP Oracle is a reality!

Splendid! :-)

I'm not sure how they intend for you to set the TNS_NAMES environment  
variable. I was not familiar with /opt/local/apache2/bin/envvars but  
that sounded promising. If that is still important to you, have you  
tried using SetEnv within the httpd.conf?

http://httpd.apache.org/docs/2.2/mod/mod_env.html#setenv