Re: FW: Oracle 8 on win2k

Vince LaMonica wrote: > On 2000-08-19, PhiRo stated: > > } >1) What version of Oracle client to you have installed on your web server? > } > } Version 8.0.5.0.0 > > To get php4win to work, you *must* use 8i - 8.1.6 to be exact. Precisely :) > } >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. > > Yes, but an ORACLE_HOME *must* be defined on the client machine. It must > point to a dir that is NOT a network drive. Same thing for your > TNSNAMES.ORA file. The ORACLE_HOME var on a server is different. The appropriate ORACLE_HOME directory will be created when you installed the client software... for 8.1.6 (which you MUST be running to get current oci8 extension to work) the default is "c:\oracle\ora81" (you'll find a bin directory below your ORACLE_HOME with all the oracle client dlls (including oci.dll and ociw32.dll - the main oci connectivity dlls) Also, make sure that this c:\oracle\ora81\bin directory (default, make this specific to your install) is in your system path (right click My Computer... select Properties... then Environment tab... edit the Path line). This way, php4 and apache can locate the appropriate dlls from you client install. You DON'T want to use the oci.dll which may have come with your php4.0.2dev. If you don't have your own oci.dll on your server, then you don't have the right client software :) > SetEnv TNS_ADMIN "D:\ora816\network\admin" > > SetEnv ORACLE_HOME "D:\ora816" I haven't found the TNS_ADMIN env variable to be necessary (I don't have it set) - but it couldn't hurt :) Vince, do you have the oracle bin directory in the path? Perhaps this is why the TNS_ADMIN var might be necessary... just a thought. Also, not sure if there's a performance penalty in relying strictly on apache/php searching the path for oracle dlls (hmmmmm). -- Andy Hoffman Web Developer Bristol-Myers Squibb email: andy.hoffman@bms.com