Prior to MDAC upgrades on IIS 4 NT4 SP6 we experienced problems with ANY web site that used custom login and connection DLL's. If one went down all ASP requests stayed queued. Updated to MDAC2.5 SP2. Now if one web site goes down due to errant ASP requests the others can stay running. Noticed something else as well. Some of the sites would use the same custom DLL for login. When one site would go down the DLL would lock and all ASP requests would queue. Now all Sites have to use their own DLL.
Also noticed a speed increase when we removed the ORACLE ODBC Drivers(vers. 7.x & 8.x) and began to use the Microsoft Oracle ODBC Drivers. This did necessitate removing all ';' in SQL statements, but it did speed things up.
Has anyone else noticed these behaviors or contrary to them?>
Go Canucks! (rabid Vancouver Canucks Fan)
Also noticed a speed increase when we removed the ORACLE ODBC Drivers(vers. 7.x & 8.x) and began to use the Microsoft Oracle ODBC Drivers. This did necessitate removing all ';' in SQL statements, but it did speed things up.
Has anyone else noticed these behaviors or contrary to them?>
Go Canucks! (rabid Vancouver Canucks Fan)