Re: Problem Connecting to Remote Oracle Server

"Emore, Emmanuel" wrote: > I am running Oracle 8, Apache Web Server and PHP 4.0.3 on Windows NT. I can > connect to the Oracle database on the NT box without any problem., but I can > not connect to a remote Oracle database. I can connect to the remote > databases using SQL+ and tnsping works as well. > > After trying unsuccessfully in trying to connect to the remote oracle > database, I decided to reinstall everything on another computer. Now I get > the following error message when phpinfo() is trying to load the Oracle OCI > extension: > Unable to load dynamic library '/php4/extensions/php_oci8.dll' - > Access is denied. > > The php_oracle.dll and php_pdf.dll extensions loads OK. > > Previous installation was giving TNS:could not resolve service name, but the > php_oci8.dll extension loaded OK. > > What am I doing wrong? 1) What version of the Oracle Client are you running... In my experience, the client version that loads the best (with least problems) is 8.1.6... I HIGHLY recommend upgrading to that version of the Oracle Client (OCI) if you're not running it already. 2) On the second machine (the one NOT loading the oci8 extension), what setting to you have for your "extension_dir" in php.ini?... as it is trying to load this using a "/dirname" directory structure, instead of "c:/dirname", I have a feeling this is part of your problem on this second server. -- Andy Hoffman Web Developer Bristol-Myers Squibb email: andy.hoffman@bms.com