Legacy

[Fred]

Hi All,

I have a legacy ADOCE dll that I need to get working with
an application that uses ADO.NET.

We use this legacy component for database access... Is
there any way to work ADOCE with ADO.neet?

thanks,
Fred

 

[Paul Clement]

¤ Hi All,
¤
¤ I have a legacy ADOCE dll that I need to get working with
¤ an application that uses ADO.NET.
¤
¤ We use this legacy component for database access... Is
¤ there any way to work ADOCE with ADO.neet?

Possibly. Is this a COM based component or Windows DLL? What data types are used for your function
call arguments?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Guest]

Hi Paul,

Thiis is a Windows DLL and we basically pass a SQL string
to the component and it returns a Recordset. Like GetRows.

Thanks,
Fred.

-----Original Message-----

¤ Hi All,
¤
¤ I have a legacy ADOCE dll that I need to get working with
¤ an application that uses ADO.NET.
¤
¤ We use this legacy component for database access... Is
¤ there any way to work ADOCE with ADO.neet?

Possibly. Is this a COM based component or Windows DLL?

What data types are used for your function

 

[William \(Bill\) Vaughn]

Yes, many DLLs can be wrapped (VS.NET will do this for you) in a COM interop
layer. When it arrives you should be able to access the Recordset using COM
Interop wrapped ADO classic. Would I recommend this approach? Nope. I would
re-write the DLL to return a DataSet.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

Hi Paul,

Thiis is a Windows DLL and we basically pass a SQL string
to the component and it returns a Recordset. Like GetRows.

Thanks,
Fred.

-----Original Message-----

¤ Hi All,
¤
¤ I have a legacy ADOCE dll that I need to get working with
¤ an application that uses ADO.NET.
¤
¤ We use this legacy component for database access... Is
¤ there any way to work ADOCE with ADO.neet?

Possibly. Is this a COM based component or Windows DLL?

What data types are used for your function

 

[Paul Clement]

¤ Hi Paul,
¤
¤ Thiis is a Windows DLL and we basically pass a SQL string
¤ to the component and it returns a Recordset. Like GetRows.
¤
¤ Thanks,
¤ Fred.

Sounds like it should be possible. First I'm assuming that this is a 32-bit DLL and you're returning
an ADODB.Recordset object. If this is the case then you can either stick with ADO, using COM
Interop, or simply dump the returned ADODB.Recordset contents into an ADO.NET DataSet using the
OleDbDataAdapter Fill method.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)