Hi Everybody,

I am trying to connect with a remote Oracle server without any success.

First, I properly installed Oracle Instant Client (I can connect to my instance using SQL*Plus or Toad with the same Desktop). Here are the path variables I defined so far:

PATH: C:\PathToOracleInstantClient
LD_LIBRARY_PATH: C:\PathToOracleInstantClient
ORACLE_HOME: C:\PathToOracleInstantClient
TNS_ADMIN: C:\PathToOracleInstantClient

Then I have a tnsnames.ora here:

C:\PathToOracleInstantClient\tnsnames.ora

The content of that file is:

testtns =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)
)
(CONNECT_DATA =
(SERVICE_NAME= MyServiceName)
)
)

Then, when I create a new Oracle connection, I put "testtns" in the "TNS Name" section, my username and password.

Then, when I click "OK" it says "Checking for hostname". Then an error is returned: "Hostname testtns is not resolved. ...".

Then, if I try to extent my Oracle connection, I get the "Cannot find OCI DLL: oci.dll". I am not sure these two issues are related, but in any case, it seems that PHPEd has some issues finding Oracle Instant Client's home folder.

Is there something I am missing to make this work?

Thanks!

Take care,

Fred

try to connect using hostname specified in "HOST = ..." line
I just tried with Oracle 10g XE and successfully connected to it using localhost. My tnsnames.ora below:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mycomputername)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

XE name worked too, but required me to say Yes when prompted to enter the hostname "anyway"