http://www.php.net/manual/en/function.ocilogon.php
tells you
int OCILogon (string username, string password [, string db])
so i assume that TEST is your User, web the password and pwd the
TNS-Identifier ?
I have a 8.1.6 DB (i guess thats what you have too), i#m using OCI8 libaries
and connecting to that remote server from more than 10!! different Machines
on the network, using PHP, JDBC and various Management Tools. It does work
believe me - Although sometimes it is difficult to set it, since there are
quite a few things that can go wrong.
the TNS names must match, (consider that a default_DOmain might be added
(sqlnet.ora))
the IP and Port of the remote DB have to match, as well as the Service or
the SID
ORACLE_HOME and sometimes some other ORA-Eniironments have to be set inside
apache or PHP or by explicity call.
mk
-----Ursprüngliche Nachricht-----
Von: Randall Barber [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 12. Februar 2001 18:37
An: [EMAIL PROTECTED]
Betreff: [PHP-DB] Oracle connectivity
There was a post a few days ago here that indicated that PHP could only talk
to Oracle databases if they resided on the same machine as the script
because PHP could not deal with the TNS resolutions or something to that
nature.
I have an Oracle database that I need to connect to on another machine (I'll
call it LIVE).
The tnsnames.ora has the appropriate entry in it for TNS resolution to an IP
connected database.
I used Net8 to create the DSN mapping.
When I use,
OCILogon("TEST","web","pwd");
I get a TNS resolution error (which I was able to FINALLY overcome), and now
I get "Could not connect to remote host." type error.
I am running WinNT 4.0 w/IIS, PHP4.
Now the reason I think its PHPs problem is because I can connect to the
database using ASP and VBScript.
I BELIEVE (not certain), that the client version I am running is 8.0.1.6. I
am "assuming" (yikes) that the phpoci.dll is the one I needed, not the
phporacle.dll. I have tried both and receive similar errors. Even using
the ODBC component of PHP returns similar errors as above.
Any suggestions are welcome.
RDB
--
PHP Database 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]
