I have a Windows Server 2008, running IIS 7, using FastCGi for handling PHP code - this all works, and I can run php scripts that don't involve oracle.
I have added php_oci8.dll to my php.ini, and set the extension_dir to the right location.
I've installed oracle instant client for 10.2.0.4 (which I'm told is the right version for the oracle db) on the web server, and have set the windows PATH to point to the directory it's installed in (making sure it comes before anything else).
running phpinfo confirms that oci8 is enabled, and the server path contains the client dir.
I also installed sql*plus, and when logged into with:
user = user
pwd = pass@host/db
it works fine and lets me run queries.
However, whenever I try to run the following:
Code: Select all
$conn = oci_connect($user, $pass,'host/db');[text]Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the directory with Oracle Instant Client libraries in C:\inetpub\wwwroot\Portals\testoci.php on line 3[/text]
Please can someone help me with this? It's driving me insane....