Oracle 9i client/IIS 5.1/PHP (4.3.1) - ORA-12154 error but only under IIS PHP

[megablst]

Hi, newbie to the forum so hope you can help.

I have on my Windows XP pc, Apache, IIS 5.1, Oracle 9i client, PHP 4.3.1 and IE 6 web browser. I have a server elsewhere with an Oracle 8.1.7 database on it.

• My Oracle 9i client works - I can use SQL Plus.

• My PHP app works through Apache to the Oracle database

• My PHP app does not work through IIS 5.1 (ISAPI and/or CGI) to the Oracle database. -->I get the dreaded ORA-12154 error.

So I know the Oracle client is fine, and the PHP app is fine (it works on Apache). It's just the IIS/PHP combination with the Oracle 9 client that fails.

I previously had an Oracle 8i client and the whole shebang worked fine. The only thing that has changed is that I changed the 8i client for the 9i client.

Any help much appreciated.

[calleope]

The problem with IIS is that it runs under a restricted user.

You will need to enable this user (IUSR_COMPUTERNAME and/or IWAM_COMPUTERNAME) to access the oracle/bin folder in the security settings of the folder.

PHP will run as the same user, and so the php_oci8.dll will not be able to access the oracle client libs unless you do this.