Thx Peter,
I have spent some time on the oracle site. They focus on troubleshooting
the Net8 connection, which works fine.
I am not sure what you mean when you ask if apache is setup correctly to
access Oracle. When running a phpinfo() environment query it shows that oci8
is enabled. Is ther more I need to do?
Thx,
Barry
"Peter J. Krawetzky" <[EMAIL PROTECTED]> wrote in message
001201c11147$66dc0510$[EMAIL PROTECTED]">news:001201c11147$66dc0510$[EMAIL PROTECTED]...
> This is saying that your request to connect to Oracle via php and apache
is
> failing because it cannot find the tnsnames.ora file. Is apache setup
> correctly to access Oracle?
>
> Also, if you want detailed information on an error message from Oracle,
> logon to the Oracle server with owner id of oracle and type in oerr ora
> 12154. This works for any Oracle error message.
> -----Original Message-----
> From: Barry Prentiss <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Date: Friday, July 20, 2001 2:02 PM
> Subject: Re: [PHP-DB] 'ORA-12203: TNS:unable to connect to destination'
> error
>
>
> >Thx Stathis,
> > I get the same response as before:
> > Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name
> in
> >c:\program files\apache group\apache\htdocs\dna\dna_oci_sys_list.php on
> line
> >20
> > Anything else I can try?
> > Barry
> >
> >"Rouvas Stathis" <[EMAIL PROTECTED]> wrote in message
> >news:[EMAIL PROTECTED]...
> >> Barry Prentiss wrote:
> >> >
> >> > Hi All,
> >> > I finally got past the php_oci8.dll problem by moving it to the same
> >> > directory as php.exe and changing the php.ini extensions_dir back to
> >'./'.
> >> >
> >> > Now I am getting the following error:
> >> >
> >> > Warning: _oci_open_server: ORA-12203: TNS:unable to connect to
> >> > destination in c:\program files\apache
> >> > group\apache\htdocs\dna\dna_oci_sys_list.php on line 20
> >> >
> >> > which occurs at the $conn line below:
> >> >
> >> > error_reporting (E_ALL);
> >> > putenv('ORACLE_HOME=C:\orant');
> >> > putenv('TNS_ADMIN=C:\orant\NET80\ADMIN');
> >> > putenv('ORACLE_SID=SLAC');
> >> > putenv('TWO_TASK=SLAC_TCP');
> >> >
> >> > $conn = ociLogon("user","password");
> >>
> >> Try, OciLogon("user","pass",'SLAC'). What do you get?
> >>
> >> -Stathis.
> >>
> >> >
> >> > This implies that I am reaching the Net8 oci client libraries
(right?).
> >> >
> >> > My environment: PHP 4.0.5, Apache 1.3.19, W2K, Net8 8.0.6.0.0, remote
> >Oracle
> >> > 8.1.6 on Solaris.
> >> >
> >> > I can connect through SQL*Plus, tests OK through Net8 assistant,
> >> > tnsnames.ora is in proper place (as defined in TNS_ADMIN above).
> >> >
> >> > What am I doing wrong?
> >> > Thx in advance,
> >> > Barry Prentiss
> >
> >
> >
> >--
> >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]
> >
>
--
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]
