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
_______________________________________________
macports-users mailing list
[email protected]
http://lists.macosforge.org/mailman/listinfo/macports-users
