Hi there,

we are developing application for users with different database environment.
I ve tested it with MySQL and SQL.
Now I am stuck on Oracle 10g.
I am trying php and PEAR.


I have the following parameters:

Windows Server 2000
PHP 4.3.6
PEAR 1.8
APACHE 2.0.49
Oracle 10g

- ORACLE_HOME = C:\oracle\product\10.1.0\db_1 in ...Oracle\KEY_OraDb10g_home1 in 
Registry
ORACLE_SID = webEvalOracle
(same variables in ...Oracle\SYSMAN\OracleDBConsolewebEvalOracle in Registry)

- WEBEVALO =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = tonya)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = webEvalO)
    )
  )
in TNSnames.ora

- php.ini:

extension=php_oci8.dll
extension=php_oracle.dll


errors are: 

1. for PEAR:  [nativecode=ORA-12154: TNS:could not resolve the connect identifier 
specified]
    /*php code:
     $dbms="oci8";
     $dbhost="tonya"; //localhost or tonya 
     $dbuser="root";   // schema name
     $dbpass="my_pass"; 
     $dbname="webevalo"; //or "webevaloracle" for the full name
 
     $connectionObj=new connectionClass($dns);
    */

2. in PHP can't connect either( $dbconnect=OCILogon($dbuser, $dbpass, $dbname))

So I was wandering if you can help me - either give me some advises or may be point to 
the source where I can retrieve the info I need.

really appreciate your time and help
Tonya
www.one45.com

Reply via email to