Hi Guys,
Not sure what your problem is since i haven't run apache on WIN32....
but tnsping only tells you that the listeners is running, not that
you can connect to the database...
Use sql*plus to connect and then you can be sure your Oracle client
is installed and configured correctly.
If you have all you environment variables set it should work OK..
BTW i'm not sure if putenv("ORACLE_HOME=D:\PROGRA~1\ORAWIN95"); is
ok, i think you should put the full path name in without any ~
or try installing oracle directly on the C: drive so you get a path
with no spaces in it
Otherwise it must be something to do with the way php has been compiled ...
if you do a phpinfo() do all the environment variables look OK and
is OCI8 support complied ?
I have connected remotely from linux/apahe to a variety of oracle
DB's on a variety of remote platforms
HTH
Steve Farmer
At 4:39 PM -0600 8/2/01, Mark Farver wrote:
> > 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
>
>
>--
>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]
--
---------------------------------------------------
"Minds are like parachutes, they work best when open"
Support free speech; visit http://www.efa.org.au/
Heads Together Systems Pty Ltd http://www.hts.com.au
Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081
--
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]
