This content has been marked as final. Show 5 replies
There's little IIS and Oracle info on the web; when you have solved your problem please post a clear solution.
How exactly did you try to set the Oracle environment variables.
There is some information in Access denied on php_oci8.dll and php_oracle.dll
I've also seen hints to make sure oracle\bin is in $_ENV['PATH']. You probably need to reboot if you change any environment to make sure IIS inherits the changes.
Because it's IIS, I set the env vars manually. That means --> my computer/.../advanced/environment vars/etc.
After every change, I rebootet the IIS Service. Problem consists.
Let's have a look, if your links could help...
########## EDIT ##########
Ok, your links WERE INDEED REALLY helpful!
My problems were caused by missing access-rights.
How to solve this problem:
* reinstall your Oracle-client
* inet-user needs now access rights for
+ "oracle"- folder
+ "oracle\bin"- folder
+ "tnsnames.ora"- file
* set environment vars
+ NLS_LANG = AMERICAN
+ ORACLE_HOME = "C:\oracle\ora92"
+ TNS_ADMIN = "C:\oracle\ora92\network\ADMIN"
* restart IIS
Now it should work!!! THX for your help!
Thanks for the summary.
For the record, one of the directories Oracle looks in for tnsnames.ora is ORACLE_HOME\network\admin. So TNS_ADMIN doesn't need to be set unless you are using another location for tnsnames.ora.
To make it easier for the next person, I wrote up your solution and posted it on http://blogs.oracle.com/opal/#a24
I should have mentioned that because you are using PHP 5.1.2 on Windows, you should pull the latest php_oci8.dll from http://pecl4win.php.net/ext.php/php_oci8.dll to avoid a threading bug.
Thanks for the link. I'll replace the dll immediately.