Return ADODB.Recordset type from .NET to Classic ASP

I have a DAL that I want to return an ADODB.recordset when executed from a classic asp. The object is exposed as a com object and I have a complete dal workin but I am not sure how to return an object that is a recordset that .net can use.

Any help would be aprcitated. Thank you!

--Nicolas

Answers


You need to add a reference to the COM base ADODB in your Web Project along with a a reference to your DAL component. You should then be able to use the component much like you were in ASP.

That said you should read this KB:-

KB312111

I would strongly recommend you consider porting your DAL to a .NET assembly first.


I think you both for your feedback, but what I was looking to do was probably misunderstood, due to a poorly written question. I found a link to a page that did exactly what I was looking for.

What I have is a DAL that is an Assembly that I wanted to expose to ASP but to do so, to prevent from having to rewrite to much code I needed to first find a way to return a type of a recordset ONLY when called from Classic ASP apps. This would happen VIA a COM exposed method call that would make the call to the DAL and convert the returned .NET DataSet as a VB RecordSet.

Here is the link that I found that made this possible. http://www.codeproject.com/KB/database/ADOConversion.aspx

Once Again, Thank you for your help and your input, and I apologize for such a poorly written question.

--Nicolas


Need Your Help

Connect to MySQL on AWS from local machine

mysql amazon-web-services remote-access

I am trying to set up a dev environment on my local machine that accesses a MySQL DB on AWS, but I keep getting a "Can't connect" message.

How many bits are necessary to address 32 bytes?

byte bits unsigned-integer

Sorry this is a really silly question, was just looking through an old exam paper for my Operating Systems class and noticed this question can come up every so often. How does one work out the answ...

Comparing four numbers in C

c linux

I wrote a simple digits comparison program in C, while compiling its throwing me an error message stating that