On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,602 Users
  • 2,269,762 Discussions
  • 7,916,789 Comments

Discussions

Problem with oracle database connection - oci

973930
973930 Member Posts: 1
edited Nov 13, 2012 5:48PM in PHP
Hello

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/[email protected] - this is working
The Oracle client is : Oracle_OraClient10g
Installed database : Oracle Database 11g Express edition

Please help.

Answers

  • Christopher Jones-Oracle
    Christopher Jones-Oracle Member Posts: 1,657 Employee
    You have:
    $polaczenie = oci_connect(elin1,maleDUZE9,$deskryptor, 'AL32UTF8');
    Shouldn't that be:
    $polaczenie = oci_connect($uzytkownik,$haslo,$deskryptor, 'AL32UTF8');
    I suggest you add this to the top of your script so you can see any errors:
    error_reporting(E_ALL);  // In PHP 5.3 use E_ALL|E_STRICT
    ini_set('display_errors', 'On');
    There is a free book that shows how to connect. You can simplify some things in your code. The book is at http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html

    You can only have one of the extensions uncommented in php.ini.
This discussion has been closed.