Unanswered: inconsistent OUTER JOIN results from 2 servers
I've encountered a mystifying phenomenon in executing the same ASP code (VBScript) on our two servers, test and production.
A SELECT query produces a list of medical procedures performed on patients, and associated reports (if any). The SELECT statement accumulates data from multiple tables using a LEFT OUTER JOIN clause, so that procedures which have no associated report will be listed. On the TEST server, the listed procedures include those which have no associated reports; the same code executed on PROD server does not display these procedures. I can't understand how or why two identically-configured IIS servers would produce different results using the same SELECT statement, but they are.
The code is exactly the same on each of the two boxes; the servers, while not identical hardware, are as close to identical software configuration as possible, even given that one is a test box. NT4, SP6a, IIS4...
The db is MS-Access97; I'm using a system-DSN to hit it. I've triple-checked that MDAC is the same on both boxes (v2.5SP1, as per db vendor specs). Comcheck results on TEST server showed 3 files are slightly newer than expected; PROD server show no discrepancies at all (1st time I've ever seen that happen). Regardless, I ran "comcheck /d" on PROD anyway, reconfigured / reinstalled MDAC 2.5SP1, just in case - no such luck.
try this: clear your test database, and copy some representative data down from the production database
if you still get different results, then it's a software issue, and i cannot help you any further than what you already have tried (in fact, i would not have been able to advise you on even half of the stuff you've already done)
Thank you - but the data source is common for both web servers. The data doesn't reside on either of these servers, it's on another server.
Because the web app specs are read-only, I've taken the risk of testing on "production" data. I actually do have a test installation of the db, but I use it only when doing more potentially "dangerous" development work.