C Chang wrote:
>
> 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
HA! I found the problem. There is little different of the ASP page.
Actually, I am puzzled why the ASP did not crash. Becasue there is a
dismatch of procedure call and the real procedure specification , which
the ASP engine should crash but did not, so when The data return, the
RSobj became NULL, so return data different. Thanks .
C Chang
Received on Tue Sep 11 2001 - 22:26:12 CDT
