NuSphere Forums Forum Index
NuSphere Forums
Reply to topic
Oracle connection: Cannot find OCI DLL: oci.dll & TNS na


Joined: 01 Oct 2010
Posts: 7
Reply with quote
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
View user's profileFind all posts by fgiassonSend private message
Site Admin

Joined: 13 Jul 2003
Posts: 7901
Reply with quote
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"

_________________
The PHP IDE team
View user's profileFind all posts by dmitriSend private messageVisit poster's website
Oracle connection: Cannot find OCI DLL: oci.dll & TNS na
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 5 Hours  
Page 1 of 1  

  
  
 Reply to topic