MDAC Dependency

I understand that ADO.Net has some dependency on MDAC 2.6 or later
(from MSDN documentation). Please correct me for the following:

"If I am going to use either System.Data.SqlClient OR
System.Data.OracleClient namespaces for data access, as they directly
communicate with database (without the support of respective OLE-DB
drivers), MDAC dependency can be avoided"

--
Rao TRN

Cowboy
Wed Jun 02 07:49:40 CDT 2004

Not sure.

SqlClient is 100% native. OracleClient still requires the Oracle library. In
each case, you are not using OleDb Providers. I would assume that MDAC could
be avoided, but I have not tested whether or not any "helper" classes are
used from the MDAC. If there are, you are sunk.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
"Rao" <trn_study@hotmail.com> wrote in message
news:2a775351.0406012257.6bbe7b87@posting.google.com...
> I understand that ADO.Net has some dependency on MDAC 2.6 or later
> (from MSDN documentation). Please correct me for the following:
>
> "If I am going to use either System.Data.SqlClient OR
> System.Data.OracleClient namespaces for data access, as they directly
> communicate with database (without the support of respective OLE-DB
> drivers), MDAC dependency can be avoided"
>
> --
> Rao TRN

Pablo
Wed Jun 02 15:37:47 CDT 2004

SqlClient actually DOES have a dependency on MDAC in .NET versions 1.0 and
1.1. Although SqlClient doesn't use oldb or odbc, it uses the network
libraries installed by MDAC to communicate with the server (that's the only
native portion of SqlClient - the rest is all managed).

Just FYI, in .NET 2.0 SqlClient will no longer depend on MDAC or any other
external component at all :)

--
Pablo Castro
Program Manager - ADO.NET Team
Microsoft Corp.

This posting is provided "AS IS" with no warranties, and confers no rights.


"Rao" <trn_study@hotmail.com> wrote in message
news:2a775351.0406012257.6bbe7b87@posting.google.com...
> I understand that ADO.Net has some dependency on MDAC 2.6 or later
> (from MSDN documentation). Please correct me for the following:
>
> "If I am going to use either System.Data.SqlClient OR
> System.Data.OracleClient namespaces for data access, as they directly
> communicate with database (without the support of respective OLE-DB
> drivers), MDAC dependency can be avoided"
>
> --
> Rao TRN

trn_study
Wed Jun 02 23:18:02 CDT 2004

Thank you all for the information.

--
Rao TRN

"Pablo Castro [MS]" <pablocas@online.microsoft.com> wrote in message news:<e9pK4FOSEHA.3944@TK2MSFTNGP11.phx.gbl>...
> SqlClient actually DOES have a dependency on MDAC in .NET versions 1.0 and
> 1.1. Although SqlClient doesn't use oldb or odbc, it uses the network
> libraries installed by MDAC to communicate with the server (that's the only
> native portion of SqlClient - the rest is all managed).
>
> Just FYI, in .NET 2.0 SqlClient will no longer depend on MDAC or any other
> external component at all :)
>
> --
> Pablo Castro
> Program Manager - ADO.NET Team
> Microsoft Corp.
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "Rao" <trn_study@hotmail.com> wrote in message
> news:2a775351.0406012257.6bbe7b87@posting.google.com...
> > I understand that ADO.Net has some dependency on MDAC 2.6 or later
> > (from MSDN documentation). Please correct me for the following:
> >
> > "If I am going to use either System.Data.SqlClient OR
> > System.Data.OracleClient namespaces for data access, as they directly
> > communicate with database (without the support of respective OLE-DB
> > drivers), MDAC dependency can be avoided"
> >
> > --
> > Rao TRN