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

[Luther, Ron]

Hi Dean | Chris,


I had a similar-sounding problem yesterday.  I could get into Oracle via
SQL+ and/or the Oracle ODBC Test utility (and several other
applications) but not with an ASP connection string.

My IM buddy sent me a new tnsnames.ora file anyway and had me load it in
C:\ORANT\NET80\ADMIN\tnsnames.ora as well as
C:\ORANT\NETWORK\ADMIN\tnsnames.ora.

They mumbled something about global and local names files that I didn't
quite get -- (Dean may know) -- but it worked.

HTH,

RonL.


-----Original Message-----
From: Dean Mah [mailto:dmah at shaw.ca]
Subject: Re: Re[2]: [thelist] PHP/Oracle Connect Problems....

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.


Chris Ditty writes:

>      Yup.  Been there.  The tnsnames.ora file exists.  I can connect
to the
>      database using sql+ with no problems.