I need to use a legacy OLE data provider that was designed to work with VB6. We have done some testing and the OLE provider will not work reliably with the .Net tools.
The plan is to write class object of some sort in VB6 that will execute the legacy provider and return data back to a VB.Net web service. The web service will then respond client requests for the data.
I have written a number of Windows applications using VB6, but I haven't tried to write a class library using VB6. Also as I understand it, the class will have to be a COM object in order for it to be used by VB.Net.
Can anyone tell me if I have to create a COM object to make this work?
Can anyone provide me with VB6 sample code that can be used as a starting point for this effort?