Thanks for this, Randall. I haven't previously tried upgrading to Oracle 8.1.6.0
because my PC will not support this revision of Personal Oracle, which I have used a
lot in the past. However, I could sacrifice personal oracle now, and just have SQLNet
and SQLPlus on my machine, which I think it will handle.
Euan
-----Original Message-----
From: Randall Barber [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 16:35
To: Greig, Euan
Subject: Re: [PHP-WIN] RE: Can't connect to Oracle
Upgade your client to the 8.1.6.0 release. This fixed all the problems I
myself was having on windows platforms.
BTW: It appears to be a PHP problem (or was in my case). With the older
versions of the client I could connect to Oracle using ASP, ODBC (not from
PHP), and everything BUT PHP. When I upgraded, the thing worked.
BTW: I believe php_oci8.dll has an 8 in it for a reason. Not sure though.
Hope that helps,
RDB
----- Original Message -----
From: "Greig, Euan" <[EMAIL PROTECTED]>
To: "Herbert Groot Jebbink" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, March 13, 2001 3:21 AM
Subject: [PHP-WIN] RE: Can't connect to Oracle
> I've had exactly the same problem, so will be very interested in an answer
too. I have spent (wasted) a lot of time trying to resolve it myself, using
every variant on every variable I could imagine. I decided it might be a
win95 problem, as the same setup works on win98.
>
> -----Original Message-----
> From: Herbert Groot Jebbink [mailto:[EMAIL PROTECTED]]
> Sent: 12 March 2001 16:48
> To: [EMAIL PROTECTED]
> Subject: Can't connect to Oracle
>
>
> Hi,
>
> I can't connect from a win95/Apache setup to a Oracle database
>
> - The PHP version is 4.04pl1 (Nusphere)
> - The location for tnsnames.ora is c:\orawin95\network\admin\tnsnames.ora
> - De Oracle version is 7.3.4.0.0
> - De SQL*NET client version is 2.3.4.0.0
> - Using the SQL PLUS 3.3 client on this machine works fine:
> - The Oracle module is active in php.ini
>
> The test program:
>
> <?php
> putenv('ORACLE_HOME=c:\orawin95');
> putenv("ORACLE_SID=WKDS");
> $conn = ora_plogon("hgj@wkds", "hgj");
> ?>
>
> The result:
>
> Warning: Unable to connect to ORACLE (ORA-12154: TNS:could not resolve
> service name) in /www/data/ontwikkel/test/php/test3.php on line 5
>
> Someone a idea whats wrong?
>
> Greetings, Herbert
>
> --
> The Trans-Siberian Railroad Page: http://herbert.groot.jebbink.nl
>
>
> **************************************************************************
> Any opinions expressed in this email are those of the individual and
> not necessarily the Company. This email and any files transmitted with
> it, including replies and forwarded copies (which may contain alterations)
> subsequently transmitted from the Company, are confidential and solely for
> the use of the intended recipient. If you are not the intended recipient
> or the person responsible for delivering to the intended recipient, be
> advised that you have received this email in error and that any use is
> strictly prohibited.
>
> **************************************************************************
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
**************************************************************************
Any opinions expressed in this email are those of the individual and
not necessarily the Company. This email and any files transmitted with
it, including replies and forwarded copies (which may contain alterations)
subsequently transmitted from the Company, are confidential and solely for
the use of the intended recipient. If you are not the intended recipient
or the person responsible for delivering to the intended recipient, be
advised that you have received this email in error and that any use is
strictly prohibited.
**************************************************************************
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
