Visual Studio 2008 Error Message

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • MarcW

    Visual Studio 2008 Error Message

    I have a fresh install of VS2008, and when I drag a data grid on and
    try and
    bind it (create a new connection) I get an error.
    If I connect to a database in the database window and then try and
    drag a
    table into a dataset, I get the same error.
    The error is: "Some Update Commands Could not be generated
    automatically.
    The database returned the following error: Failed to find or load
    the .NET
    Data Provider"

    Any ideas? It happens with an SqlConnection (MS SQL 2005) and an
    Access
    connection. Others in my office can do it fine.


    I reformatted my PC last week because of a borked .NET installation,
    and now
    this. It's doing my nut.


    Any ideas or suggestions much appreciated.


    Marc
  • Marc Wickens

    #2
    Re: Visual Studio 2008 Error Message

    On Wed, 6 Aug 2008 00:56:54 -0700 (PDT), MarcW <wrote:
    >I have a fresh install of VS2008, and when I drag a data grid on and
    >try and
    >bind it (create a new connection) I get an error.
    >If I connect to a database in the database window and then try and
    >drag a
    >table into a dataset, I get the same error.
    >The error is: "Some Update Commands Could not be generated
    >automaticall y.
    >The database returned the following error: Failed to find or load
    >the .NET
    >Data Provider"
    >
    >Any ideas? It happens with an SqlConnection (MS SQL 2005) and an
    >Access
    >connection. Others in my office can do it fine.
    >
    >
    >I reformatted my PC last week because of a borked .NET installation,
    >and now
    >this. It's doing my nut.
    >
    >
    >Any ideas or suggestions much appreciated.
    I have managed to fix this problem. Here is the solution for anyone
    else who may get it.

    I also have another IDE on my system, CodeGear (Formally Borland
    Delphi) RAD Studio.
    I don't use any of the Borland database stuff, so I chose not to
    install the providers when installing RAD Studio.

    However it still added an entry to <DbProviderFact oriesin my
    machine.config.
    So I commented out the line
    "<add name="AdoDbx Data Provider"
    invariant="Borl and.Data.AdoDbx Client" description=".N et Framework Data
    Provider for dbExpress Drivers"
    type="Borland.D ata.TAdoDbxProv iderFactory, Borland.Data.Ad oDbxClient,
    Version=11.0.50 00.0, Culture=neutral ,
    PublicKeyToken= 91d62ebb5b0d1b1 b"/"

    I am guessing that it could not be found, and this was cuusing all
    other providers to have an error. With this commented out, Data Grids
    now work (and bind automatically) without any error messages.

    I'd be interested to know who's at fault here. Rad Studio for the
    entry, or Visual Studio for not recovering from this entry.

    Regards

    Marc

    Comment

    Working...