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
Received on Mon Sep 10 2001 - 03:42:24 CDT
