Dear All,



I've developed an application that make use of MTS component to access 

quite huge amount of data (around 4 GB) on SQLServer 7 database.



The MTS component is built under Ms. VB 6, in which database query stored, 

and the result is returned to ASP as array variable.



I've read one article (forget which one), which suggested to make use of 

datatype variant for the parameter in the mts module, but then I read 

somewhere else again that it is not suggested.

(1.) Actually what should be the best solution? Variant or specific 

datatype?



(2.) Also, some pages return Out Of Memory error when the request is being 

made (directly, like 2 seconds).



Err, the server runs on PIII 600, with 512MB of memory and 20GB hd.

The IIS and SQL Server reside on the same machine.



(3.) I also noticed that, in the task manager, several mtx.exe remain in 

the process (consumed like 1-2MB of memory). Is this normal, or 

something's missing in the MTS component?



Hope someone can give me some enlightment here :)





Thanks in advance,