Unfortunately, upgrading the Oracle boxes is not an option. The current
Oracle version databases are part of a massive, already in production system
and is out of the question. We're adding additional components and I
STRONGLY recommended using PHP for server-side functionality.
If I can't connect to a remote Oracle 8.0.5 from PHP, I'll have to use some
other tool, like ASP.... I would really not like to do that there's a
possibility that the additional components be moved to a Unix box. If I
initially use ASP, then moving to Unix is out of the question...
Anyone else have this problem (PHP to Oracle 8.0.5)??
Later,
Jorge
[EMAIL PROTECTED]
----- Original Message -----
From: Randall Barber <[EMAIL PROTECTED]>
To: Jorge Santos <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 10:42 PM
Subject: Re: [PHP-DB] Oracle & WinNT4/2000
> Try upgrading to Oracle Client 8.1.6. That was only way I could get it to
> work right. For whatever reason, PHP and oracle don't get along on
Windows.
> I can use ASP no problem on those earlier versions of the oracle client.
>
> If you can't find the 8.1.6 client, let me know, I'll give you a link to
the
> one I found. (200M sheesh).
>
> Our remote server is 8.0.2.4 I think. Not much trouble connecting to the
> older server with the new client, just couldn't get PHP to do anything.
>
> > Randall,
> >
> > I have the basic setup but still can't make it work... My versions are
> > different however. Here's what I have:
> >
> > Remote Server Oracle 8.0.5
> > Web Server: Apache on Windows 95 with Oracle Client (SQL Plus 8.0.5)
> > Also tried Web Server: IIS4 on Windows NT 4.0 Service pack 4, same
Oracle
> > Client
> > (Note: I can tnsping and connect to the database with sql plus from both
> > boxes)
> >
> > I have TNS_ADMIN and ORACLE_HOME set:
> > I also tried setting ORACLE_SID as well.
> > I am using OCI (php_oci8.dll).
> >
> > I'm still getting the
> > Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name
> in
> > ...
> > error message...
> >
> > Could you provide advice and/or additional details... (I think it's a
> > problem with the Oracle client version 8.0.5 drivers and PHP but since I
> > don't have another version of Oracle to test with....)
> >
> > Thanks for the help...
> > Later,
> > Jorge
> > [EMAIL PROTECTED]
> > ----- Original Message -----
> > From: Randall Barber <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, February 14, 2001 4:35 PM
> > Subject: [PHP-DB] Oracle & WinNT4/2000
> >
> >
> > To anyone who cares:
> >
> > I recently was able to get the following setup to work correctly with
PHP
> > connecting to an oracle database from Windows:
> >
> > Remote Server: Oracle 8 (8.0.2.4)
> >
> > Web Server: Win2000, Oracle 8i Client (8.1.6.0) w/8.1.6.3 ODBC Drivers
> > (separate download) (for odbc functions)
> >
> > I have tested it on PHP ASAPI with no problems. I suspect the CGI
version
> > will also work.
> >
> > Used PHPOCI8.DLL extension.
> >
> > I have TNS_ADMIN, ORACLE_HOME environment variables defined.
> >
> > NOTE: The earlier client release 8.0.2.4 does not work on Win2k or
WinNT4
> > (at least I couldn't get it to). The 8.1.6 client is the only one that
> > supports Win2k (future versions will, just nothing previous will have
> Win2k
> > support added).
> >
> > Hope this helps anyone who is having trouble,
> > RDB
> >
> > P.S. - I'm happy to give greater details to anyone who wants them
> >
> >
>
--
PHP Database 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]
