[PHP-DB] Oracle/PHP Instant-Client ( remote connection )

Hello all, Hope this isn't an FAQ - have trawled google, otn.oracle, php.net etc - not sure I can find the answer.. I've been using phpmySql for a while now and getting on great - however I'm now tasked with getting my php to talk to a _remote_ ( right next to me but separate ) Oracle server...

Re: [PHP-DB] Oracle/PHP Instant-Client ( remote connection )

Comments below. Jim Morrison wrote: Hello all, Hope this isn't an FAQ - have trawled google, otn.oracle, php.net etc - not sure I can find the answer.. I've been using phpmySql for a while now and getting on great - however I'm now tasked with getting my php to talk to a _remote_ ( right next

[PHP-DB] Oracle + PHP

Hello I have Oracle 9 + RedHat 7 + PHP 4.3.4 + Apache 1.3.29. I've compiled apache and php I've compiled PHP using the documentation and activating OCI. I've build the typical script for starting apache, it's like this: $ORACLE_HOME=blablahblah... more oracle variables

Re: [PHP-DB] Oracle + PHP

Luis Moran Ochoa wrote: I've build the typical script for starting apache, it's like this: $ORACLE_HOME=blablahblah... more oracle variables Are the environment variables exported in the script?: ORACLE_HOME=/my/oracle/home export ORACLE_HOME Are all variables needed set? Are

Re: [PHP-DB] Oracle + PHP

Yes they are... I tried to put them into the httpd.conf file, like: SetEnv ORACLE_HOME /usr/oracle and so The problem still remains. Too, I've put all the environment variables in the root env into the script I thought it can be a problem with a missed variable But it doesn't

Re: [PHP-DB] Oracle + PHP

Perhaps something that isn't obvious is missing. If you post more detail (e.g. the exact script and the exact permissions) someone might be able to help you. Chris Luis Moran Ochoa wrote: Yes they are... I tried to put them into the httpd.conf file, like: SetEnv ORACLE_HOME /usr/oracle and

[PHP-DB] Oracle/PHP Issue

Hello, I am having a strange issue with Oracle and PHP. I am running PHP Version 4.3.4 on Red Hat AS 2.3 and trying to connect to Oracle 9i also on Red Hat AS 2.3. I compiled PHP successfully with OCI and oracle. My script uses the ocilogon($user, $password, $db); or ora_logon($user.'@'.$db,

[PHP-DB] Oracle + PHP + Linux Red Hat {again}

Please, any idea to resolve my problem!!! I have the output: Connected to DataBase Oracle! Warning: OCIStmtExecute: ORA-03106: fatal two-task communication protocol error in /var/www/html/ora2.php on line 21 Warning: OCIFetchStatement: ORA-24374: define not done before fetch or execute and

[PHP-DB] Oracle/PHP question...

Yes, you need to recompile PHP: ./configure --with-oci8=[your_oracle_home] -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup

Re: [PHP-DB] Oracle/PHP question...

, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity

Re: [PHP-DB] Oracle/PHP question...

] -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting

Re: [PHP-DB] Oracle/PHP question...

=[your_oracle_home] -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my

RE: [PHP-DB] Oracle/PHP question...

Correct. I am working on Unix, specifically HP-UX 11.00. -Original Message- From: Andrey Hristov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 8:38 AM To: xxx ; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Oracle/PHP question... AFAIK he uses *nix, not windows

Re: [PHP-DB] Oracle/PHP question...

- Original Message - From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] To: 'Andrey Hristov' [EMAIL PROTECTED]; xxx [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:37 PM Subject: RE: [PHP-DB] Oracle/PHP question... Correct. I am working on Unix, specifically HP

Re: [PHP-DB] Oracle/PHP question...

Compile with --with-oci8 Andrey - Original Message - From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] To: 'Andrey Hristov' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:56 PM Subject: RE: [PHP-DB] Oracle/PHP question... I am running Oracle 8.0.6.3. Do I need

[PHP-DB] Oracle/PHP question...

I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable to logon to database.); ? I have installed the Oracle client on

RE: [PHP-DB] Oracle/PHP question...

PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable

RE: [PHP-DB] Oracle/PHP question...

Thanks, but my web server is HP-UX. Didn't anyone ever tell you Win-blows sucks? :) -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 3:07 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... If your

RE: [PHP-DB] Oracle/PHP question...

- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 2:08 PM To: Ryan Jameson (USA); [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... Thanks, but my web server is HP-UX. Didn't anyone ever tell you Win-blows sucks

RE: [PHP-DB] Oracle/PHP question...

. :-D Ryan -Original Message- From: Ryan Jameson (USA) Sent: Monday, December 16, 2002 2:15 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... :-) ... Windows is the best at running the C# .NET applications I have to build to :make everyone happy that we are industry

RE: [PHP-DB] Oracle/PHP question...

can admit to possibly being a closet Unix fan. :) -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 3:19 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... BTW... I'm not the one stuck trying to figure out how

Re: [PHP-DB] oracle php abstraction layer

On Saturday 06 April 2002 19:34, Pedro M.S. Oliveira wrote: Hi all ;) usually i just use mysql with php, but this time i will need to access an oracle database, knowing oracle is not a problem, but i'm searching for a DB abstraction layer that is tested and working. as i never used this

Re: [PHP-DB] Oracle-PHP (contd.)

Are you sure you need an environment variable to store that? if yes, this script should do the trick : putenv(TNS_ADMIN=/ora1/app/oracle/product/8.1.6/network/admin); --- $tns = getenv(TNS_ADMIN); echo $tns; Regards, Philippe Vandana [EMAIL PROTECTED] a écrit dans le message news: [EMAIL

[PHP-DB] Oracle-PHP (contd.)

With reference to my previous problem in connecting to the oracle database, I found out some additional information. I defined the TNS_ADMIN variable in the startup file and added this line to my php-script: putenv(TNS_ADMIN=/ora1/app/oracle/product/8.1.6/network/admin);

[PHP-DB] Oracle-PHP

I've just installed php4.0.4 , apache-1.3.14 and oracle8.1.6 on my RedHat 7.0 machine.I am trying to write a php script to connect to my oracle database.But I am facing problems.When I used the oci8 functions as follows: ?php putenv(ORACLE_SID=sid);

[PHP-DB] Oracle - PHP

Hi: I have PHP with mySQL compiled in. We are about to attempt to connect to Oracle. Of course we have to rebuild PHP with the added Oracle support, but I was just wondering if anyone has done this and if so, could you offer any noteworthies or comments about using PHP with Oracle. Thanks!