RE: [PHP-WIN] Trying out Oracle 8 calls.
| From: | Asendorf, John | Date: | Fri, 03 Nov 2000 12:58:27 +0000 |
| Subject: | RE: [PHP-WIN] Trying out Oracle 8 calls. | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-3663@lists.php.net to get a copy of this message | ||
Dear Peter,
This is an Oracle problem. I wish I could help you more, but I just
hollared to our Oracle DBA and he fixed it...
Our method of attack went like this:
1) make sure you can hit the Oracle server from the webserver by pinging it
2) double check the Oracle connection with SQL Plus
3) Use a VERY simple SQL command when testing the Oracle logon
4) MAKE SURE you are using Oracle Client 8.1.6 on the webserver (free to
download)
---------------------
John Asendorf - jasendorf@lcounty.com
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
> -----Original Message-----
> From: Sham, Peter [mailto:peter.sham@lendware.com]
> Sent: Thursday, November 02, 2000 3:59 PM
> To: 'php-windows@lists.php.net'
> Subject: [PHP-WIN] Trying out Oracle 8 calls.
>
>
> Hi all,
>
> I just downloaded the latest PHP and trying out Oracle 8 calls on NT.
> However, I can't even get through a simple OCI_Logon. I got
> this message
> all the time:
>
> ORA-12154: TNS:could not resolve service name
>
> I've tried to run sql-plus and everything was fine. I'm sure that my
> tnsnames.ora was setup right. If anyone can help. Please.
>
> Peter.
>