I am having no luck connecting to a remote oracle database using php
4.04p1 under Win95. Using the ora_logon, oci_logon, and oddly enough
odbc_connect fucntions always returns a TNS:could not resolve service
name. SQL PLUS, and a number of ODBC programs all work
correctly. Reading the sqlnet.log files reveals that php is trying to
access the default BEQLOCAL database. Watching PHP with filemon shows
that php (or more likely an oracle dll loaded by php) checks to see that
the tnsnames.ora file is available.. but never reads it. One workaround
listed is to add the ORACLE_SID environment variable, but this only causes
it to try to connect to that SID on the local db.
There are quite a few bugs in the bug database similar to my problem
#6342,#6936,#8132 and others.
Another test I tried was a passthru("tnsping80 mydb") which pinged the db
successfully and implies that its not an environment problem but something
to do with how the oracle DLL's are accessed.
I can pass along dumps of the sqlnet.log files and others if anyone is
interested.
Thanks
Mark Farver
--
"The greatest dangers to liberty lurk in insidious enroachment by mean of
zeal, well-meaning but without understanding."
-- Justice Louis O. Brandeis, Olmstead vs. United States
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
