Absolutely best way is to download 2.7 and use it. Means pure ADO.NET.

If you are using VS.Net, then it's very easy to import COM objects into
projects (ADO 2.6/older is COM-based, that I meant. Of course 2.7 can be
used via COM, but it's needed to use ADO.NET also). Just click
Project->Add Reference->COM and choose the COM object(s) you want to
import. VS.NET creates namespaces for those imported objects. For
example, imported ADO objects would be under ADODB namespace.Then they
are available as normal .NET objects.

If you are not using VS.NET, then you have to create type librarys for
COM objects manually. It happens using .NET Frameworks's Type Library
Importer tool. It creates interop assemblys that can the be used in .NET
applications. I haven't done these much myself so I cannot explain
details but they all are found in .NET Framework SDK. If you want to
know more, check that.

Teemu Keiski

-----Alkuper=E4inen viesti-----
L=E4hett=E4j=E4: Jon Ege Ronnenberg [mailto:007-is-his-iq@o...]
L=E4hetetty: 24. toukokuuta 2002 16:35
Vastaanottaja: ADO.NET
Aihe: [ado_dotnet] Re: VS: What version of ADO/MDAC do I need?


What namespace would they be under then?
And how do I import classes via COM?
Maybe I should just download ADO 2.7 and spare us all from this problem.
But just out of curiosity please answer the questions above.

Thanks Teemu.

> I think that if you use ADO 2.6 or older, you have to import the
> classes
via COM (Someone correct if I'm wrong). Then, of course, they are not
under System.Data.OleDb namespace.

Thanks a bounce for the heads up.