Re: strange TNS-12154

Ed Stevens <nospam_at_noway.nohow> wrote in message news:<50ulvvkk159jrlj021cv46g8curs5p9tfc_at_4ax.com>...
> Peter,
>
> Sever based, client based . . . . they are all clients to Oracle.
 

That's true, VB application can be link database directly from clients, but in the web environment (ASP/IIS) client's browser request the info to web server and web server make a connection to the database server via oracle client(OCI).

> I'm
> still waiting to hear back from the developer as to where he was
> executing his stand-alone vb code vs. the ASP code. If they were both
> being executed on the web server box . . . .

eventhogh vb code from web server can use map drive info of tns name without problem. but not the IIS.

>
> I don't understand your assertion that "IIS does not like an Oracle
> client information in other server." What does IIS know or care about
> anything to do with Oracle?

Refrence http://support.microsoft.com/default.aspx?scid=kb;en-us;255084 item 5.
Check to make sure that the Oracle client components are installed locally on the IIS server. While it is possible to get other applications to work without the Oracle components installed locally, this causes problems when you work with ASP applications. Microsoft recommends that these components be installed on the IIS server; other custom configurations are not supported. (PERIOD.... ;-) Is IIS standing *between* the ASP code
> and the Oracle SQL*Net interface?

Actually more than that, ado (mdac) interface with ole(oracle) also involved.

free ASP code to navigate Oracle table/view and dynamic query, please download code from www.exmlsoft.com

> On 3 Jan 2004 21:22:32 -0800, pchq45_at_hotmail.com (Peter Chong) wrote:
>
> >Hi, Ed
> >First of all, ASP is Server base application and Vb is client base
> >application.
> >And Second of all, IIS does not like an Oracle client information in
> >other server, It like to keep the Oracle infomation in same IIS
> >server.
> >Peter C.
> >
> >Ed Stevens <nospam_at_noway.nohow> wrote in message news:<ad5stvsoqunrhjiorlijuitagfcj7oo4cl_at_4ax.com>...
> >> Oracle 8.1.7 client on Win2k server
> >> Oracle 8.1.7.4 db on different Win2k server
> >>
> >> Background -- we keep a central TNSNAMES file in a non-Oracle
> >> directory on one of our main DB servers. Let's say it is on dbsvr01at
> >> x:\app_info with the \app_info directory shared as app_info. As part
> >> of the Oracle client installation, whether on a desktop or a web or
> >> app server, we set TNS_ADMIN=\\dbsvr01\app_info. We set this into
> >> HKLM\LOCAL_MACHINE\ORACLE and HKLM\LOCAL_MACHINE\HOME0. This
> >> arrangement has been rock-solid for us for several years.
> >>
> >> Got a msg from a developer working with some web apps that he had been
> >> getting TNS-12154 (could not resolve service name) errors from some
> >> new ASP modules he had just placed on the web server. He said the asp
> >> code returned the tns-12154, but when he took the code out of the asp
> >> and created a simple vb exe, it worked ok. He then added the
> >> 'missing' tnsnames entry to the local tnsnames file (there is a
> >> security issue I need to address, but is not germaine to my question)
> >> the asp page worked.
> >>
> >> Problem is, with the registry entries set the way they are (and I
> >> confirmed myself that they are correct) I don't understand how
> >> anything he could have done to the local tnsnames could have had any
> >> effect. Or, alternatively, why the simple vb exe would have worked,
> >> but the asp page didn't.
> >>
> >> I don't know much about how these asp pages are put together, so I ran
> >> it past another developer that I trust, and she couldn't come up with
> >> an explanation either.
> >>
> >> So I'm on a bit of a fishing expedition . . . and am running out of
> >> bait. Does anone have any ideas?
Received on Tue Jan 06 2004 - 21:20:10 CST