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