classic asp receiving an array from a VB.NET DLL

[Stuart Shepherd]

Due to historic reasons, I have a classic ASP application that calls a DLL written in VB.NET. The function in the DLL populates a two dimensional array with the contents of a SQL Server table (using ADO.NET). This array is then passed back to the ASP application to be displayed to the user.

The problem I am experiencing is when I attempt to reference the array in the ASP application a Type Mismatch error occurs. I cant seem to find a way around this problem. any ideas?

thanks in advance.
Stuart

[alex_read]

In vb.net, the array is of a more complex object data type, and I'm guessing some of it's properties and methods such as the ".sort" function this object has is confusing your vb6/asp code.

You could strip the array down into a comman delimited string for vb6 to take it in, or the gotdotnet site http://samples.gotdotnet.com/quickst...tClient_1.aspx may be able to provide some other way to do achieve this.

[Stuart Shepherd]

thanks for your reply. i found the following link below concerning my problem (almost). the article deals with array passing between VB6 and VB.Net and not classic ASP. You would have assumed the code to work in ASP but it doesnt. Still getting the type mismatch error when attempting to reference the array.

I will have to find an alternative method of passing back information.

How Do I...Pass an Array From .NET Code to VB6 Code?
http://samples.gotdotnet.com/quickst...tClient_1.aspx

thanks any way.
Stuart