We have ASP pages on a Web server with VB6 components that produce the majority of the HTML. These components run on the same machine as the the Web server. Is there a way to put these components under MTS on the same machine? The goal is to obtain the benefits of just-in- time activation and ODBC connection pooling.
Sure, it's no problem to do that. MTS can be installed on the same machine as IIS.
I typically have one component that manages the database connection(s), and the other components talk to it to do their data access. The only thing that the ASP page gets back is either a disconnected recordset or a string with a bunch of HTML in it.