We used to get this error on both IIS 5 and IIS 6 with oracle 9i.
Its the permissions issue on oracle directory.
php_oci8.dll and php_oracle.dll call other dlls from the oracle client directory. If the IIS is allowed to use the anonymous logon it uses IUSR_<machinename> account to read the files, therefore this user needs to have read access on oracle installation directory.
Hi! I do not know if you still have the problem, but I had the same... Finally I found a document on google which wrote that three dll files I have to copy to the folder where TNSNAMES file is... Unfortunatelly I do not remember the name of the files, but one of them was oci.dll, and there were six or seven files in the same folder so you can copy all...
Hi could you please tell me where did you install this file? Could you give me proper location of this TNSNAMES folder? And the files you installed i think they are oracle instant client. could you please confirm this to me?
If you've set the environment variable TNS_ADMIN, this is where it'll expect to find tnsnames.ora. Otherwise the last resort is $ORACLE_HOME/network/admin. (On unix systems it also checks either /etc/oracle or /var/opt/oracle depending on the version of unix.)
However, if you're using the OCI driver and specifying hostname,port and Oracle sid (or servicename) in your connection details, then tnsnames.ora isn't used, since you've already specified explicitly everything it would need to get from that file.
Additionally, if you're using Oracle instant client, then tnsnames.ora is not used and you have to explicitly specify hostname,port,service_name/(or sid) to connect