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