Re: Problem of IIS server to different but same content Oracle engine.

Niall Litchfield wrote:
>
> Are absolutely definitely 100% sure that the sql being executed by the two
> .asp pages is the same? I would suspect that it isn't. Or possibly that the
> data is different. My money would be on the sql tho'.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "C Chang" <cschang_at_maxinter.net> wrote in message
> news:3B980B63.219_at_maxinter.net...
> > I have one develop web server (IIS 4 on NT) and one production web
> > server (IIS 4 on NT) and one develop oracle server (8i) and one
> > production server (8i). I just tried somthing today by changing the
> > Host name of the tnsnames on my develop web server pointing to the
> > produciton oracle server, I found out that querying the same table of
> > that on pruduction Oracle, I got different return (missed a lot of
> > records). since both the asp page of two web servers are same and the
> > content of the table are the same. How does this happen? does anyone
> > has a clue? Besides changing the Host name of the tnsname, do I need to
> > change anything else. I have tried to
> > 1. remove the ODBC driver on the web and recreate a same one, but it did
> > not work,
> > 2. used the IP address instead of the Host name in the tnsnames, not
> > work either.
> > 3. I did a cross connection ( prod web server -> develop oracle server,
> > same result).
> > 4. Stop and start the Web server, not working.
> > 5 the Listener on the oracle server is set with the right IP address.
> >
> > I am running out the solutions,can any one hlep? greatly appreciate.
> >
> > C Chang

Hi Niall:

   Thanks. I have tried again using two web servers to connect the same DB server, and the result of query was different. Since I am using the procedure call in my ASP page, so I definitely absolutely sure. On ther hand, the ASP codes from the 2 web server are the same too ( exactly). To be sure again, I will compare the ASP files again tomorrow. Thanks again.

C Chang Received on Mon Sep 10 2001 - 21:48:29 CDT