returning ADO disconnected recordset from VB.NET to VB 6.0 app

[Guest]

I am trying to return a disconnected recordset from a VB.NET dll to a VB 6.0 app. The function in the .NET Dll runs without error and when I check the record count it show 1 which is correct, but when I go to view the values in the field they are empty. My question is can you create a ADO disconnected recordset with VB.NET? If yes then what could I be doing wrong, if no what other options would I have to return a disconnected recordset to the VB app. Rewriting the VB app is not an option at this time. I do know you can transform a dataset into a recordset but I'm trying to avoid that.

Thanks,
Kent

 

[Calvin Luttrell/ProjectThunder.com]

Kent,

I thought the OLEDB provider for ADO .Net has a method for returning data as a Recordset. I am not seeing it in 1.1. The post below on google seems to address what you are trying to do.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q318559

http://groups.google.com/groups?q=o...off&selm=l1Y9bXKTCHA.2096@cpmsftngxa08&rnum=1

Good Luck!



-Calvin Luttrell
www.projectthunder.com
Enter to win a XBOX or a Portable DVD Player
Monitored forums www.projectthunder.com/forums