[PHP-DB] Oracle TNS no listener

2007-06-07 Thread steve
Hi All I've a bit code that connects to a remote Oracle DB, does a simple query and returns the result. Running from a Windows command prompt as php oratest.php the script runs fine and returns the results I'm expecting. If I run it through a browser I get oci_connect()

Re: [PHP-DB] Oracle TNS no listener

2007-06-07 Thread David Mitchell
Have you rebooted windows since setting the environment variable? I believe that's the only way for windows services to see the change. HTH On 6/7/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi All I've a bit code that connects to a remote Oracle DB, does a simple query and returns the

Re: [PHP-DB] Oracle TNS no listener

2007-06-07 Thread Christopher Jones
Make sure TNS_ADMIN is set to the directory name, not the file itself. Also consider using the Easy Connect syntax. We don't cover IIS in the Underground PHP Oracle Manual, but there may be some useful information e.g. on the various connection syntaxes in the OCI8 driver. The URL is: