Re: Oracle & WinNT4/2000

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 santos@net-lynx.com ----- Original Message ----- From: Randall Barber <rdb55@email.byu.edu> To: Jorge Santos <santos@net-lynx.com> 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 > > santos@net-lynx.com > > ----- Original Message ----- > > From: Randall Barber <rdb55@email.byu.edu> > > To: <php-db@lists.php.net> > > 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 > > > > >