Posted by dan_e on 10/26/06 07:11

Hi,

I have got PHP 5 working on this windows box with APACHE 2.2. I cannot
however get PHP to connect to an oracle database.

Here is all the info that may help determine what i'm doing wrong.

PHP.ini file has been change to show the following:

(under Windows extensions)
extension=php_oci8.dll
extension=php_oracle.dll

I have unzipped the oracle 10.2 client and placed my tnsnames.ora file
in there with the following:

DJD1 =
(DESCRIPTION =
(SDU=4096)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dusrvdb)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = djd1.corp.cranegroup)
)
)

I have set the system environment variables on the windows box with the
following

Path = C:\PHP\instantclient_10_2;c:\...etc (more paths)
tns_admin = C:\PHP\instantclient_10_2

The \instantclient_10_2 directory only holds the dll's, etc and my
tnsnames.ora file.

There is a version of Oracle 9.2 installed at this location:
c:\Oracle\Ora92\Bin....(and all the other dirs)

but i make no reference to it (should i?)

Below is the php code i am using to try and determine if i get a
connection or not:

<?php
$database = OCILogon("the_username", "the_password", "DJD1");
if(!$database)
die("<H1>Unable to connect!</H1>");
OCILogOff($database);
echo("<H1>SUCCESS!</H1>");
?>

If someone could please offer any advice that would great! I have done
a little with PHP before, but never touched Oracle. I am clueless...

many thanks,
Dan.

• Next in forum: Complex select query
• Prev in forum: CURL Post?
• Thread view: Please Help! - PHP 5 + APACHE 2.2 + ORACLE 10.2 on windows box

[Reply to this message]