RE: [PHP-WIN] PHP4 and Oracle 8.0.5/WinNT
| From: | Trussell David N | Date: | Thu, 16 Nov 2000 15:32:45 +0000 |
| Subject: | RE: [PHP-WIN] PHP4 and Oracle 8.0.5/WinNT | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-3907@lists.php.net to get a copy of this message | ||
Use an editor and save the TNSNAMES.ORA file in Unix format. I don't know if
that bug has been fixed now or not, but it's really obscure.
> Hi Bod,
>
> Since I'm not a PHP guru nor an Oracle dba, my answer is
> probably pretty
> stupid. But... the one thing I've noticed while using this
> combination is
> that the error you're receiving (TNS names blah blah) is almost always
> either a coding error in your PHP (check and double check the
> service) or a
> TNSnames file problem.
>
> If you can hit the dB with SQL Plus, I would bet that the
> problem is in the
> PHP code.
>
> If you still have some problems, hit us with some code next
> time. We can
> help you much better if you do that.
>
> John
>
> ---------------------
> John Asendorf - jasendorf@lcounty.com
> Web Applications Developer
> http://www.lcounty.com - NEW FEATURES ADDED DAILY!
> Licking County, Ohio, USA
> 740-349-3631
>
> Caesar si viveret, ad remum dareris.
>
>
>
> > -----Original Message-----
> > From: Bod [mailto:bara_skrap@hotmail.com]
> > Sent: Thursday, November 16, 2000 9:08 AM
> > To: php-windows@lists.php.net
> > Subject: [PHP-WIN] PHP4 and Oracle 8.0.5/WinNT
> >
> >
> > Hello!
> >
> > I guess I should apply to join the "What Kind of Idiot Uses
> > PHP with IIS
> > with Oracle on NT?" consortium... but I must! Coding PHP feels much
> > better then coding ASP, and the code will be moved to a
> HP-UX machine,
> > so no ASP! This beside the fact that it feels good. :)
> >
> > The machine situation is a Windows NT 4 server with IIS 4, and the
> > server is running an Oracle 8.0.5 database.
> >
> > PHP3 had no problems connecting to the database, nor had it
> > any problems
> > connecting to external databases. PHP4, enter the scene. No more
> > connections. Always the good old "TNS:could not resolve
> service name".
> > I've browsed through all the messages in here, and
> everything point on
> > one thing - upgrade to Oracle 8.1.6. And this will be a problem... I
> > need to stay on Oracle 8.0.5 as that will be the situation once the
> > application is put in production.
> >
> > I installed the 8.1.6 client separately, but the system is
> not to fond
> > of this, and as I am still getting the same error from my attempted
> > connection (using ora_logon) I belive that the 8.0.5 system is still
> > being used by PHP.
> >
> > Anyone? What is the situation with PHP4 and connecting through 8.0.x
> > clients and even old 7.3.4 clients?
> >
> > In advance, thank you.
> >
> > Bod, Sweden
> > bara_skrap@hotmail.com
> >
> >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-windows-help@lists.php.net
> > To contact the list administrators, e-mail:
> > php-list-admin@lists.php.net
> >
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
> For additional commands, e-mail: php-windows-help@lists.php.net
> To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
>