RE: [PHP-WIN] FW: Oracle 8 on win2k

From: Date: Fri, 18 Aug 2000 23:14:58 +0000
Subject: RE: [PHP-WIN] FW: Oracle 8 on win2k
References: 1  Groups: php.windows 
Request: Send a blank email to php-windows+get-1981@lists.php.net to get a copy of this message
> I begin to suspect I might be better off to build Oracle access components > in COM and call these from php. But there is off course a performance and > time penalty for that. (Also the matter that I could work with ASP for all > that matter because in such case php has no gain over ASP) > > Cheers PhiRo >Wash your mouth out with soap, immediately! Them's fightin' words round here :) LOL I was afraid that would start a ruse... <Blub...> >Anyway, a couple questions to ask you about your installation before we can get >this squared away. Oracle and php (either odbc or oci8) are very finicky at the >moment. >1) What version of Oracle client to you have installed on your web server? Version 8.0.5.0.0 >2) Where is your ORACLE_HOME directory located (local drive vs. network drive)? It is not defined on the webserver. There is only an Oracle client installed., Oracle itself runs on another machine. Mind you. All other ODBC and OLEDB including SQL plus run trouble free on this machine it uses the tnsnames.ora file to config the connection to the database. On the database server ORACLE_HOME is pointed at the e:\orant directory. (local) >3 tnsnames.ora is defined : ( IP adres is masked ) # C:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration File:C:\orant\net80\admin\tnsnames.ora # Generated by Oracle Net8 Assistant DEMO1.WORLD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.x.x)(PORT = 1521)) (CONNECT_DATA = (SID = ORCL)) ) TCP-LOOPBACK.WORLD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SID = ORCL)) ) Access for the ora-client directory has been granted for the IUSR_xxx account the webserver uses. This is what i have. 'preciate your help Cheers PhiRo

« previous php.windows (#1981) next »