Problem with oracle database connection - oci
973930Nov 13 2012 — edited Nov 13 2012Hello
I am writing an html page and I want to connect with the oracle database. I am using oci, this is the code:
$host = "IP";
$port=1521;
$nazwa_uslugi = "XE"; // dbServiceName
$uzytkownik = "elin";
$haslo = "maleDUZE9";
$deskryptor = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST=$host)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=XE)))";
echo "AAA2 deskryptor = $deskryptor ";
$polaczenie = oci_connect(elin1,maleDUZE9,$deskryptor, 'AL32UTF8');
echo "AAA3";
if(!$polaczenie)
{
$err = oci_error();
trigger_error('Nie mozna nawiazac polaczenia z baza danych: '. $err['message'], E_USER_ERROR);
echo "AAA4";
}
echo "AAA5";
On the page is displaying everything till -> echo "AAA2 deskryptor = $deskryptor ";
After that nothing happens, no information about error, nothing...
In php.ini I tried to used to options (only one probably can be used):
extension=php_oci8.dll ; Use with Oracle 10gR2 Instant Client
extension=php_oci8_11g.dll ; Use with Oracle 11gR2 Instant Client
and no positiv results.
The Oracle client is installed and is working properly:
sqlplus user/passwd@xe - this is working
The Oracle client is : Oracle_OraClient10g
Installed database : Oracle Database 11g Express edition
Please help.