Re: OCI8 broken in CGI, but works in ISAPI?
| From: | Andy Hoffman | Date: | Wed, 13 Sep 2000 13:50:11 +0000 |
| Subject: | Re: OCI8 broken in CGI, but works in ISAPI? | ||
| References: | 1 | Groups: | php.db php.windows |
| Request: | Send a blank email to php-db+get-2867@lists.php.net to get a copy of this message | ||
Florian Clever wrote:
> Hi,
>
> I just noticed something interesting. I have the same PHP script trying
> to connect to Oracle via OCI8. When run through the ISAPI module it will
> connect + return proper data, but with CGI it returns Warning: ORA is
> unable to resolve TNS. Using SQLPlus I am also able to connect.
>
> The configuration is the exact same for both scripts (same server (but
> .php as ISAPI and .phtml as CGI)):
> WinNT 4 SP6a, IIS 4, PHP4.0.2 from php4win.de.
Question, how do you have your Oracle Service identified for this particular
database instance... (check Net8 Assistant). Make sure that you are using
Oracle 8.0 Compatible Service Identification - defines connections by older
SID instead of the new SERVICE NAME convention.
--
Andy Hoffman
Web Developer
Bristol-Myers Squibb
email: andy.hoffman@bms.com