Forum Stats

  • 3,827,682 Users
  • 2,260,803 Discussions
  • 7,897,336 Comments

Discussions

Cannot Connect to Oracle 9i DB Server

452573
452573 Member Posts: 82
edited Nov 6, 2013 3:52PM in PHP
Hi,

My problem is, I cannot connect to Oracle 9i DB Server. I tried to run the php_info() and it displays: <br><br>

OCI8 Support enabled <br>
Version 1.2.2 <br>
Revision $Revision: 1.322 $ <br>
Active Persistent Connections 0 <br>
Active Connections 0 <br>
Temporary Lob support enabled <br>
Collections support enabled <br><br>

Directive Local Value Master Value <br>
oci8.default_prefetch 10 10 <br>
oci8.max_persistent -1 -1 <br>
oci8.old_oci_close_semantics 0 0 <br>
oci8.persistent_timeout -1 -1 <br>
oci8.ping_interval 60 60 <br>
oci8.privileged_connect Off Off <br>
oci8.statement_cache_size 20 20 <br><br>

I've got this from error.log in apache server. <br><br>

PHP Warning: ocilogon() [function.ocilogon]: <br>OCIEnvNlsCreate() failed. There is something wrong with your system - please <br>check that PATH includes the directory with Oracle Instant Client libraries in <br>C:\\EID_Web\\Exercises\\connect_to_oracle.php on line 14<br><br>

PHP Warning: ociparse() expects parameter 1 to be resource, boolean given in <br>C:\\Web\\connect_to_oracle.php on line 15<br><br>

PHP Warning: ociexecute() expects parameter 1 to be resource, null given in <br>C:\\Web\\connect_to_oracle.php on line 16<br><br>

PHP Warning: ocifetch() expects parameter 1 to be resource, null given in <br>C:\\Web\\connect_to_oracle.php on line 22<br><br>

PHP Warning: ocifreestatement() expects parameter 1 to be resource, null given in <br>C:\\Web\\connect_to_oracle.php on line 32<br><br>

PHP Warning: ocilogoff() expects parameter 1 to be resource, boolean given in <br>C:\\Web\\connect_to_oracle.php on line 33<br><br>

By the way, I'm using apache server version 2.2.3 and PHP/5.2.0RC6-dev running on <br>windows 2000 as our web server. We have a remote Oracle9i DB Server.<br><br>
Thanks in advance for the help.

Comments

This discussion has been closed.