Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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


Message #1 by "Willis Johnson" <willisj@m...> on Tue, 12 Mar 2002 18:18:08 -0800
Hi Jay,

I never got your source code. Meanwhile, have you checked your 

installation with the component checker? Here's a link:



   http://www.microsoft.com/data/download.htm#CCinfo





good luck!

willis



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

From: Jay Shen [mailto:jay_shen@m...]

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

To: ADO.NET

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 =3D New DataSet("Customers")

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

> > Line 19:

> > Line 20: repList.DataSource =3D 

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').

Message #2 by "Jay Shen" <jay_shen@m...> on Wed, 20 Mar 2002 19:42:16 -0800
Hi, Willis,

Already sent you the sample code and pls let me know any fix if available.

Thanks.

Jay


>From: "Willis Johnson" <willisj@m...>
>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: Tue, 12 Mar 2002 18:18:08 -0800
>
>Hi Jay,
>I never got your source code. Meanwhile, have you checked your installation 
>with the component checker? Here's a link:
>
>    http://www.microsoft.com/data/download.htm#CCinfo
>
>
>good luck!
>willis
>
>-----Original Message-----
>From: Jay Shen [mailto:jay_shen@m...]
>Sent: Monday, February 25, 2002 12:51 PM
>To: ADO.NET
>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.
> >
> >
>
>
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
>
>
>




_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


  Return to Index