[thelist] PHP/Oracle Connect Problems....

[Dean Mah]

Actually, I didn't mean appending the domain name onto your service
name.  Oracle has (used to have?) a global_names scheme that *looks*
like domain names but aren't necessarily the same.  Check the
sqlnet.ora file to see if you have one defined.  SQL*Plus will likely
tack that onto the end automatically.

Dean


Chris Ditty writes:

>      We actually use just ip addresses here.  I tried that and it still
>      wouldn't connect. As for the mlocr_user/password at mlocr, that won't
>      work with the php oracle connection.
>
>      They say that this is a pain in the rear.  They are right.  :)
>
>
> ___________________________ Reply Separator _________________________________
> Subject: Re: Re[2]: [thelist] PHP/Oracle Connect Problems....
> Author:  thelist-admin at lists.evolt.org at INTERNET
> Date:    3/14/2002 2:06 PM
>
>
> Do you have a global_names, or something like that, defined in your
> sqlnet.ora file?  Try appending that name to your service name.  For
> example, mlocr_user at mlocr.host.com.
>
> I'm not a PHP programmer, but can you specify the connection as
> mlocr_user/password at mlocr?
>
> Dean
>
>
> Chris Ditty writes:
>
> >      Yup.  Been there.  The tnsnames.ora file exists.  I can connect to the
> >      database using sql+ with no problems.
> >
> >      any other ideas?