PDA

View Full Version : PHP and oci8 Oracle problem

danny
05-07-02, 02:45
Hi everyone,

Pls help me to solve this problem. I'm trying to do a simple connection to oracle db using oci8. But I recieve this error and don't know how to proceed.

I get the code from an article - 'Simple Connection to Oracle' at http://www.thickbook.com/extra/php_oracle.phtml but I change the sql to fit my db.

Error displyed:

Warning: _oci_open_server: ORA-12560: TNS: protocol adapter error in c:\apache\htdocs\oci_php.php on line 4

Couldn't logon.

which means I was unable to connect to Oracle db.

PLs help.

Thank you in advance.

Danny
danny
05-07-02, 02:52
:) Addtional to the message before, I'm using PHP 4.1.1, Apache 1.3.12, Oracle 9i all on platform Win98.

Thanks again.
ika
10-28-03, 09:28
Originally posted by danny
:) Addtional to the message before, I'm using PHP 4.1.1, Apache 1.3.12, Oracle 9i all on platform Win98.

Thanks again.

Do you have entry for your database in tnsnames.ora file?
Oracle Listener is started?
ualual
10-28-03, 21:43
you might want to see:


http://otn.oracle.com/tech/opensource/php/apache/inst_php_apache_windows.html