Converting Dataset into Recordset
Here's an interesting scenario, that my colleague was trying to sort-out today
I have couple of web services built using Microsoft.NET which returns DataSet.
The .NET clients are working fine, now I want two other applications to use these web services. One is Classic ASP (ASP3) based and other is PHP (4.x) based.
Any ideas how those two applications can consume my webservices and handle datasets? More specifically, can I convert dataset into ADODB recordset?
I have built .NET based proxy library, using interop the dataset is converted into ADODB recordset, but there are three bottle-necks.
- I haven’t found any way to convert dataset into recordset directly, I am transforming dataset xml into recordset-friendly xml using XSL, write that output into a file and then open a recordset from that file
- .NET proxy uses ADODB primary inter-op assembly
- .NET library is exposed to COM clients (ASP and PHP) using CCW
Is there any better alternative than what I have done?