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

Simulate click event on an svg group

javascript svg snap.svg

I have created a group using Snap.svg.

Keeping the downloaded torrent in memory rather than file libtorrent

c++ python bittorrent

Working with Rasterbar libtorrent I dont want the downloaded data to sit on my hard drive rather a pipe or variable or something Soft so I can redirect it to somewhere else, Mysql, or even trash if...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.