Accessing ADO.NET data provider from ASP "classic" page

[Joe Bleaux]

I'm not sure if this will be helpful to you, but here's what I know....

You can write a function in your codebehind that uses whatever you want to
get your data, and then call that function from your classic ASP code. Just
make your function return a recordset or whatever you want to store your
data in.

"Stephen Walch" <swalch@proposion.com> wrote in message
news:u8Z$hndXDHA.888@TK2MSFTNGP10.phx.gbl...

> I have a third-party ADO.NET data provider that I want to use from an ASP
> page. I want to avoid resorting to ADO/ODBC due to the quality of the
> "legacy" data driver, so I really need to find a solution that will allow
> the use of my ADO.NET data provider. The ADO.NET interfaces do not seem

to

> be designed with COM interop in mind, so simply generating a COM wrapper
> seems to be out of the question.
>
> So far, I can think of two possible solutions: (1) write an intermediate
> wrapper class with COM-friendly interfaces and (2) find someone who has
> written a generic ADO to ADO.NET interface. Before embarking on this
> project, I thought I would check in here to see if anyone had any

pointers.

>
> Thanks,
>
> Steve
>
>

[MSFT]

Hi Stephen,

I think you have to create a wrapper for ADO.NET, for example a class
library supporting COM interop,It is not necessary to implement all
interface in ADO, you can just expose any required interface by the ASP
appliaction. For example, a Getvalue and Setvalue method. You can treat it
as a "data layer" in your design. Anyway, you also can coosider upgrading
to ASP.NET and you wouldn't lost much for it.

Luke

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026?? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
[url]http://www.microsoft.com/security/security_bulletins/ms03-026.asp[/url] and/or to
visit Windows Update at [url]http://windowsupdate.microsoft.com[/url] to install the
patch. Running the SCAN program from the Windows Update site will help to
insure you are current with all security patches, not just MS03-026."