p2p.wrox.com: Archives - ado

ado_dotnet thread: Help on MDAC issue during development with ADO.NET

Message #1 by "Jay Shen" <jay_shen@m...> on Fri, 22 Feb 2002 06:42:53

I got this error when using SqlDataAdapter with DataSet:

Server Error in '/' Application.

-------------------------------------------------------------------------

The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data 

Access Components(MDAC) version 2.6 or later. 

Description: An unhandled exception occurred during the execution of the 

current web request. Please review the stack trace for more information 

about the error and where it originated in the code. 



Exception Details: System.InvalidOperationException: The .Net Data SQL 

Provider (System.Data.SqlClient) requires Microsoft Data Access Components

(MDAC) version 2.6 or later.



Source Error: 





Line 16: 

Line 17: 	Dim custDS As DataSet = New DataSet("Customers")

Line 18: 	custDA.Fill(custDS, "Customers")

Line 19: 	

Line 20: 	repList.DataSource = custDS.Tables("Customers").DefaultView 

 



Source File: c:\inetpub\wwwroot\test.aspx    Line: 18 



Stack Trace: 





[InvalidOperationException: The .Net Data SQL Provider 

(System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) 

version 2.6 or later.]

   System.Data.SqlClient.SqlConnection.Open() +761

   System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, 

ConnectionState& originalState) +44

   System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, 

Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior 

behavior) +98

   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 

startRecord, Int32 maxRecords, String srcTable, IDbCommand command, 

CommandBehavior behavior) +77

   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) 

+36

   ASP.test_aspx.Page_Load(Object Source, EventArgs E) in 

c:\inetpub\wwwroot\test.aspx:18

   System.Web.UI.Control.OnLoad(EventArgs e) +67

   System.Web.UI.Control.LoadRecursive() +29

   System.Web.UI.Page.ProcessRequestMain() +724



---------------------------------------------------------------------------

-----

Version Information: Microsoft .NET Framework Version:1.0.3705.0; ASP.NET 

Version:1.0.3705.0 





Pls let me know if you have any solutions to this problem.

Thanks a lot.



Jay



Have been posting on Microsoft newsgroups for a long time without any good 

workarounds so far.

Message #2 by Richard Ainsley <rainsley@p...> on Mon, 25 Feb 2002 11:40:12 -0800

Do you have MDAC 2.6 or MDAC 2.7 loaded?  They are downloadable from

Microsoft for free.  Take note of their warnings - don't use on replicated

networkwork servers  -- they are safe every where else.  When you installed

the VB.NEt you should already have MDAC2.7 installed?



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

From: "Jay Shen" <jay_shen@m...>

To: "ADO.NET" <ado_dotnet@p...>

Sent: Thursday, February 21, 2002 10:42 PM

Subject: [ado_dotnet] Help on MDAC issue during development with ADO.NET





> I got this error when using SqlDataAdapter with DataSet:

> Server Error in '/' Application.

> -------------------------------------------------------------------------

> The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data

> Access Components(MDAC) version 2.6 or later.

> Description: An unhandled exception occurred during the execution of the

> current web request. Please review the stack trace for more information

> about the error and where it originated in the code.

>

> Exception Details: System.InvalidOperationException: The .Net Data SQL

> Provider (System.Data.SqlClient) requires Microsoft Data Access Components

> (MDAC) version 2.6 or later.

>

> Source Error:

>

>

> Line 16:

> Line 17: Dim custDS As DataSet = New DataSet("Customers")

> Line 18: custDA.Fill(custDS, "Customers")

> Line 19:

> Line 20: repList.DataSource = custDS.Tables("Customers").DefaultView

>

>

> Source File: c:\inetpub\wwwroot\test.aspx    Line: 18

>

> Stack Trace:

>

>

> [InvalidOperationException: The .Net Data SQL Provider

> (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC)

> version 2.6 or later.]

>    System.Data.SqlClient.SqlConnection.Open() +761

>    System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,

> ConnectionState& originalState) +44

>    System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord,

> Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior

> behavior) +98

>    System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32

> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,

> CommandBehavior behavior) +77

>    System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)

> +36

>    ASP.test_aspx.Page_Load(Object Source, EventArgs E) in

> c:\inetpub\wwwroot\test.aspx:18

>    System.Web.UI.Control.OnLoad(EventArgs e) +67

>    System.Web.UI.Control.LoadRecursive() +29

>    System.Web.UI.Page.ProcessRequestMain() +724

>

> --------------------------------------------------------------------------

-

> -----

> Version Information: Microsoft .NET Framework Version:1.0.3705.0; ASP.NET

> Version:1.0.3705.0

>

>

> Pls let me know if you have any solutions to this problem.

> Thanks a lot.

>

> Jay

>

> Have been posting on Microsoft newsgroups for a long time without any good

> workarounds so far.




$subst('Email.Unsub').

Message #3 by "Jay Shen" <jay_shen@m...> on Mon, 25 Feb 2002 12:51:26 -0800

Thanks for the reply.

I already reinstalled everything but I still encounter this kind of problems 

from time to time.

Almost desperate now since I didn't get any workarounds for this issue from 

Microsoft newsgroups.



Jay





>From: Richard Ainsley <rainsley@p...>

>Reply-To: "ADO.NET" <ado_dotnet@p...>

>To: "ADO.NET" <ado_dotnet@p...>

>Subject: [ado_dotnet] Re: Help on MDAC issue during development with 

>ADO.NET

>Date: Mon, 25 Feb 2002 11:40:12 -0800

>

>Do you have MDAC 2.6 or MDAC 2.7 loaded?  They are downloadable from

>Microsoft for free.  Take note of their warnings - don't use on replicated

>networkwork servers  -- they are safe every where else.  When you installed

>the VB.NEt you should already have MDAC2.7 installed?

>

>----- Original Message -----

>From: "Jay Shen" <jay_shen@m...>

>To: "ADO.NET" <ado_dotnet@p...>

>Sent: Thursday, February 21, 2002 10:42 PM

>Subject: [ado_dotnet] Help on MDAC issue during development with ADO.NET

>

>

> > I got this error when using SqlDataAdapter with DataSet:

> > Server Error in '/' Application.

> > 

>-------------------------------------------------------------------------

> > The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft 

>Data

> > Access Components(MDAC) version 2.6 or later.

> > Description: An unhandled exception occurred during the execution of the

> > current web request. Please review the stack trace for more information

> > about the error and where it originated in the code.

> >

> > Exception Details: System.InvalidOperationException: The .Net Data SQL

> > Provider (System.Data.SqlClient) requires Microsoft Data Access 

>Components

> > (MDAC) version 2.6 or later.

> >

> > Source Error:

> >

> >

> > Line 16:

> > Line 17: Dim custDS As DataSet = New DataSet("Customers")

> > Line 18: custDA.Fill(custDS, "Customers")

> > Line 19:

> > Line 20: repList.DataSource = custDS.Tables("Customers").DefaultView

> >

> >

> > Source File: c:\inetpub\wwwroot\test.aspx    Line: 18

> >

> > Stack Trace:

> >

> >

> > [InvalidOperationException: The .Net Data SQL Provider

> > (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC)

> > version 2.6 or later.]

> >    System.Data.SqlClient.SqlConnection.Open() +761

> >    System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,

> > ConnectionState& originalState) +44

> >    System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord,

> > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior

> > behavior) +98

> >    System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32

> > startRecord, Int32 maxRecords, String srcTable, IDbCommand command,

> > CommandBehavior behavior) +77

> >    System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String 

>srcTable)

> > +36

> >    ASP.test_aspx.Page_Load(Object Source, EventArgs E) in

> > c:\inetpub\wwwroot\test.aspx:18

> >    System.Web.UI.Control.OnLoad(EventArgs e) +67

> >    System.Web.UI.Control.LoadRecursive() +29

> >    System.Web.UI.Page.ProcessRequestMain() +724

> >

> > 

>--------------------------------------------------------------------------

>-

> > -----

> > Version Information: Microsoft .NET Framework Version:1.0.3705.0; 

>ASP.NET

> > Version:1.0.3705.0

> >

> >

> > Pls let me know if you have any solutions to this problem.

> > Thanks a lot.

> >

> > Jay

> >

> > Have been posting on Microsoft newsgroups for a long time without any 

>good

> > workarounds so far.




>$subst('Email.Unsub').

>

>












_________________________________________________________________

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

Message #4 by Richard Ainsley <rainsley@p...> on Mon, 25 Feb 2002 15:42:40 -0800

I would like to see the entire procedure that triggers this error. Please

send to me.

 rainsley@W...

I may of some help.  Can't tell for certain with the code fragment examined

so far.



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

From: "Jay Shen" <jay_shen@m...>

To: "ADO.NET" <ado_dotnet@p...>

Sent: Monday, February 25, 2002 12:51 PM

Subject: [ado_dotnet] Re: Help on MDAC issue during development with ADO.NET





> Thanks for the reply.

> I already reinstalled everything but I still encounter this kind of

problems

> from time to time.

> Almost desperate now since I didn't get any workarounds for this issue

from

> Microsoft newsgroups.

>

> Jay

>

>

> >From: Richard Ainsley <rainsley@p...>

> >Reply-To: "ADO.NET" <ado_dotnet@p...>

> >To: "ADO.NET" <ado_dotnet@p...>

> >Subject: [ado_dotnet] Re: Help on MDAC issue during development with

> >ADO.NET

> >Date: Mon, 25 Feb 2002 11:40:12 -0800

> >

> >Do you have MDAC 2.6 or MDAC 2.7 loaded?  They are downloadable from

> >Microsoft for free.  Take note of their warnings - don't use on

replicated

> >networkwork servers  -- they are safe every where else.  When you

installed

> >the VB.NEt you should already have MDAC2.7 installed?

> >

> >----- Original Message -----

> >From: "Jay Shen" <jay_shen@m...>

> >To: "ADO.NET" <ado_dotnet@p...>

> >Sent: Thursday, February 21, 2002 10:42 PM

> >Subject: [ado_dotnet] Help on MDAC issue during development with ADO.NET

> >

> >

> > > I got this error when using SqlDataAdapter with DataSet:

> > > Server Error in '/' Application.

> > >

> >-------------------------------------------------------------------------

> > > The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft

> >Data

> > > Access Components(MDAC) version 2.6 or later.

> > > Description: An unhandled exception occurred during the execution of

the

> > > current web request. Please review the stack trace for more

information

> > > about the error and where it originated in the code.

> > >

> > > Exception Details: System.InvalidOperationException: The .Net Data SQL

> > > Provider (System.Data.SqlClient) requires Microsoft Data Access

> >Components

> > > (MDAC) version 2.6 or later.

> > >

> > > Source Error:

> > >

> > >

> > > Line 16:

> > > Line 17: Dim custDS As DataSet = New DataSet("Customers")

> > > Line 18: custDA.Fill(custDS, "Customers")

> > > Line 19:

> > > Line 20: repList.DataSource = custDS.Tables("Customers").DefaultView

> > >

> > >

> > > Source File: c:\inetpub\wwwroot\test.aspx    Line: 18

> > >

> > > Stack Trace:

> > >

> > >

> > > [InvalidOperationException: The .Net Data SQL Provider

> > > (System.Data.SqlClient) requires Microsoft Data Access

Components(MDAC)

> > > version 2.6 or later.]

> > >    System.Data.SqlClient.SqlConnection.Open() +761

> > >    System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection

connection,

> > > ConnectionState& originalState) +44

> > >    System.Data.Common.DbDataAdapter.Fill(Object data, Int32

startRecord,

> > > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior

> > > behavior) +98

> > >    System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32

> > > startRecord, Int32 maxRecords, String srcTable, IDbCommand command,

> > > CommandBehavior behavior) +77

> > >    System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String

> >srcTable)

> > > +36

> > >    ASP.test_aspx.Page_Load(Object Source, EventArgs E) in

> > > c:\inetpub\wwwroot\test.aspx:18

> > >    System.Web.UI.Control.OnLoad(EventArgs e) +67

> > >    System.Web.UI.Control.LoadRecursive() +29

> > >    System.Web.UI.Page.ProcessRequestMain() +724

> > >

> > >

>

>--------------------------------------------------------------------------

> >-

> > > -----

> > > Version Information: Microsoft .NET Framework Version:1.0.3705.0;

> >ASP.NET

> > > Version:1.0.3705.0

> > >

> > >

> > > Pls let me know if you have any solutions to this problem.

> > > Thanks a lot.

> > >

> > > Jay

> > >

> > > Have been posting on Microsoft newsgroups for a long time without any

> >good

> > > workarounds so far.




> >$subst('Email.Unsub').

> >

> >




$subst('Email.Unsub').

>

>

>

>

> _________________________________________________________________

> Get your FREE download of MSN Explorer at

http://explorer.msn.com/intl.asp.

>

>




$subst('Email.Unsub').

Return to Index

P2P Archives