Hi, i suggest the variant type because is more easy managing other data types, the variant data type it's no better type, but
VBScript use this type, if use a MTS i consider more easily variant type in your DLL parameters.



About several mtx.exe remain in your task manager i think that the process that you run, not finished with the set Object=nothing
i.e., you are not kill the process when it`s finish.





>

>Subject: Confuse [ASP-MTS]

>From: "JWINOTO" <jwinoto@y...>

>Date: Fri, 8 Mar 2002 07:35:48

>X-Message-Number: 1

>

>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,

>





___________________________________________________

GO.com Mail                                    

Get Your Free, Private E-mail at http://mail.go.com