Mark,
> Go to bugs.php.net and search thru the open bugs for "oracle" You'll find
> a good dozen bugs on Windows that seem to be describing this problem.
> #6396 and #8132 come to mind.
In addition, bug #7446 for standard Oracle
Later,
Jorge
[EMAIL PROTECTED]
----- Original Message -----
From: Mark Farver <[EMAIL PROTECTED]>
To: Jorge Santos <[EMAIL PROTECTED]>
Cc: Mark Farver <[EMAIL PROTECTED]>
Sent: Friday, February 09, 2001 9:55 AM
Subject: Re: [PHP-DB] PHP4/Apache on Win95 to remote Oracle
> On Thu, 8 Feb 2001, Jorge Santos wrote:
>
> > This isn't good news.... I'll let you know what I find out. If what you
> > stated is true, then where's the BUG list...
>
> Go to bugs.php.net and search thru the open bugs for "oracle" You'll find
> a good dozen bugs on Windows that seem to be describing this problem.
> #6396 and #8132 come to mind.
>
> Mark
>
> >
> > Thanks for the info.
> > Later,
> > Jorge
> > [EMAIL PROTECTED]
> > ----- Original Message -----
> > From: Mark Farver <[EMAIL PROTECTED]>
> > To: Jorge Santos <[EMAIL PROTECTED]>
> > Cc: PHP-DB <[EMAIL PROTECTED]>
> > Sent: Thursday, February 08, 2001 5:39 PM
> > Subject: Re: [PHP-DB] PHP4/Apache on Win95 to remote Oracle
> >
> >
> > > > Please help. I'm going maaddd trying to figure this out. I've pretty
> > much
> > > > read all of the online docs and spend countless hours reading
through
> > the
> > > > archives..
> > > >
> > > > I'm running PHP4 and Apache on my Win95 computer.
> > > > I'm trying to connect to a remote Oracle database.
> > >
> > > I had the same problem last week. Every suggestion I got was about
> > > environment variables. However since a tnsping from within PHP
> > > (using passthru) works fine I know better. From examining the sqlnet
> > > files and watching the resource allocations I came to the conclusion
that
> > > PHP is hardcoded to connect only to a database located on the same
> > > machine (using BEQLOCAL). Oracle never even bothers to read the
> > > tnsnames.ora file when its called from PHP. This seems to be only a
> > > problem in Windows and possibly only with the Oracle8 drivers.
> > >
> > > My postings to the dev lists went unanswered but at the time I was
unsure
> > > if it was a Windows only problem. It might be worth reposting this
info
> > > to the PHP-WIN list.
> > >
> > > My boss was very unhappy when I told him my code had to run on a Unix
> > > box.. I basically sold him on PHP due to is cross-paltform nature.
> > >
> > > ODBC might work instead, although it never did for me. Use ADODB or
> > > another abstraction layer.. this way you can switch back and forth
easier.
> > >
> > > Let me know if you figure anything else out.
> > >
> > > Mark Farver
> > > [EMAIL PROTECTED]
> > >
> > > On Thu, 8 Feb 2001, Jorge Santos wrote:
> > >
> > > > Hi all,
> > > >
> > > >
> > > > I'm getting a "Warning: _oci_open_server: ORA-12203: TNS:unable to
> > connect to destination ..." error message. Yet I know the environment is
ok
> > because I can tnsping the database name and I can connect using SQL Plus
to
> > the database.
> > > >
> > > > Here's the php code:
> > > >
> > > > <?php
> > > > putenv("ORACLE_SID=MDC6");
> > > > putenv("ORACLE_HOME=D:\PROGRA~1\ORAWIN95");
> > > > putenv("TNS_ADMIN=D:\PROGRA~1\ORAWIN95\NET80\ADMIN");
> > > >
> > > > $tns = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL
=TCP)(HOST
> > = njnwkora15.db.pseg.com)(PORT = 1527))) (CONNECT_DATA = (SID
=MDC6) ) )";
> > > >
> > > > $connect=OCIPLogon("MDC","MDC",$tns) or die("It's not possible to
> > connect");
> > > >
> > > > $sql = "select * from district";
> > > >
> > > > $result =OCIParse($connect,$sql);
> > > > OCIExecute($result) or die("It's not possible to query");
> > > >
> > > > echo("<TABLE>");
> > > > while(OCIFetch($result)) {
> > > > $CC = OCIResult($result,1);
> > > > $CCNome = OCIResult($result,2);
> > > > echo('<TR><TD>' . $CC . '</TD><TD>' . $CCNome . '</TD></TR>');
> > > > }
> > > > echo("</TABLE>");
> > > > ?>
> > > >
> > > > I shouldn't need to declase $tns above but I've tried with and
without
> > it. I'm also including the ORACLE_SID, ORACLE_HOME and TNS_ADMIN
variables
> > in the autoexec.bat so that they are declared as of machine bootup. I
also
> > added them to the httpd.conf for Apache configuration like this:
> > > >
> > > > SetEnv ORACLE_SID MDC6
> > > > SetEnv ORACLE_HOME D:\PROGRA~1\ORAWIN95
> > > > SetEnv TNS_ADMIN D:\PROGRA~1\ORAWIN95\NET80\ADMIN
> > > >
> > > >
> > > > Please help.... Before I switch to ASP...
> > > > Later,
> > > > Jorge
> > > > [EMAIL PROTECTED]
> > > >
> > >
> > > --
> > > "The greatest dangers to liberty lurk in insidious enroachment by mean
of
> > > zeal, well-meaning but without understanding."
> > > -- Justice Louis O. Brandeis, Olmstead vs. United States
> > >
> >
> >
>
> --
> "The greatest dangers to liberty lurk in insidious enroachment by mean of
> zeal, well-meaning but without understanding."
> -- Justice Louis O. Brandeis, Olmstead vs. United States
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
