Hi all,

I have a largish (46 programs) CGI system running under NT4.0 w/SP4, IIS4.0. It runs very well on the first server it was installed on (http://www/softwaremedia.com). It also runs well on the development server using NT4.0. SP3, IIS 3.0.

I set up a new development server that (hopefully) mirrored (http://www/softwaremedia.com). Eight of the programs ran correctly, while all of the rest failed with http error 502 (Bad Gateway). Also, all attempts to replicate the system (http://www/softwaremedia.com) to other similar production servers have failed with the same error 502. In all cases built-in traces have definitely shown that the failed programs were *never executed*.

Now the interesting part: *All* of the successfully executed programs *did not use* the MySQL C API , while *all* of the failed programs *did use MySQL*.

I KNOW that this is NOT an MySQL problem because the failed programs *were never executed* (and they all run correctly on the first server (http://www/softwaremedia.com)).

MS IIS 4 Is evidently getting confused (to put it nicely), and I don't have a solution yet.

Can someone explain to me how IIS seems to know that the program is using MySQL? The programs are not executed, and I can't find any symbols in the linker's MAP file that would tell it.. But I found an article in the MSDN database that talks about a CGI failing with a 502 (and like mine returning a CGI Error) needing a DSN for the database it was using. BUT I'M NOT USING ODBC so shouldn't need a DSN (but then, I know very little about ODBC).

Help, anybody.

Thanks, -Lew