I have very strange prob. I have two set of web environments, Dev and Prod.

Our dev. environment has one NT4.0 server. So both web server(IIS4.0) and 

db server (oracle 8.1.7 with ODBC 8.1.7.3) are on same machice. 

Our prod. environment has two NT4.0 servers. One web server(IIS4.0 & ODBC 

8.1.7.3) and other db server (oracle 8.1.7). All NT servers have SP 6a. 

Both web servers have all the fixes for IIS4.0. Both have IE5.5 sp2. The 

only difference for dev. server and pro web server is that dev server(both 

web and db) is a BDC and prod. web server is NT server. 

Problem:

========

Our programmers have written paging code to display records in pages to 

speed up the data. Now when we use the code on dev server, it works fine. 

Display all records with paging. But when use the same code on prod web 

server to access data from db, the search stops. Not only search stops but 

it also freeze the whole web page. You cannot go to any other link from 

this page. 

Now we tried several things. first thing we tried to isolate where the 

prob is. either in db server or web server. We switched the dev website 

from dev db to prod. db. It worked fine with paging. we could able to 

access data using dev website and prod. db server. So it looks to us that 

our production webserver cannot access db when we use paging. If paging is 

removed, search works fine. It can access the data. 

The differnce btw dev web server and prod web server are:

1. dev web server and db server are on same machine while prod web and db 

server are on different machine.

2. dev web server is BDC while prod web server is server. 

Any help will be highly appriciated..

Kamran Khan