Re: setting OCI8 env vars under NT

> > > Our TNSNAMES.ora file is on a network drive [G:\TNS] and it > > turns out that for some reason, php/apache can't read the TNSNAMES.ora > > file when it resides on that directory. SQL+ has no problems. If I copy > > the TNSNAMES.ora file to my D: or C: or other local dir, and adjust my > > httpd.conf file, php has no problems reading the file. > > > > Now I *think* I had attempted to do this before with 7.3.4 [copying the > > network copy of TNSNAMES.ora], and it failed, but I don't remember doing > > it with the 8.0.5 client. > > I originally had the SAME EXACT problem connecting to a network (X: drive in my instance) > install of oracle 8. I have a sneaky feeling this has something to do with Apache/PHP not > being able to path their way to a network drive (I had my x: drive oracle bin in the system > path, but Apache would never display this in it's path settings in phpinfo()) My problem > was also that ALL of the oracle client was on the network (nothing local) so not only > couldn't it find the tnsnames, but it couldn't even find the necessary oracle dlls. yech! > > But, when I installed a fresh local copy of 8.1.6 client, all the problems disappeared. > > I have a feeling that Apache won't give access to mapped network drives for one main > reason... Security. That would be a potential security hazard if apache's path environment > had direct access to other computers on a local lan. So, we may have to say that you CAN'T > access a Net8 client on a network drive, due to apache restrictions. Anyone else have > thoughts on this? Hi , sorry for a very late reply... I am catching up with old oracle related postes... I had a similar problem with apache on a alias pointing to a mapped drive. Apache used to refuse to read from this directory. Running Apache as under a different user who has access rights to the mapped directory on the other NT box solved the issue. Hope this will help. I wonder how you are running php4 to connect to Oracle. CGI or apache module? I tried all the tricks mentioned here and had no success load Apace when php is configured as a add on module, however it works fine as CGI. The other day Daniel told me that people have successusfully configured it both modes. Thanks Krishnakumar Avanoor