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

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 Thu Sep 06 2001 - 18:48:51 CDT