Re: visual basic.net standard 2003 (ado.net)

From: ado.net (ado.net_at_discussions.microsoft.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 06:17:03 -0700

Normalizing my database did not answer my question. As to why did Microsoft
limit to 100 fields on the data adapter wizard, but give the ability for more
than 100 fields in a single database table. It would take massive coding
changes to restructure my database. It was working fine in VB6 with DAO. I
still do not understand this limit. Are there any plans by Microsoft to
increase the limit. Or is this a bug? Could you clarify further. Thanks.

"William (Bill) Vaughn" wrote:

> I suggest that you look more closely at your database design. I virtually
> all cases when we've seen designs with this many columns it's because the
> database is not normalized. Since an average (albeit wide) normalized
> relational table might have 20 or 30 columns, 100 is excessive.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
>
> "ADO data adapter limit" <ADO data adapter limit@discussions.microsoft.com>
> wrote in message news:D486C190-4B8C-4CA1-AFFB-B86D1B424BF2@microsoft.com...
> > Why is there a 100 field limit when using the adapter wizard to configure
> > a
> > data adapter. I have a database that has over 200 fields and need the
> > ability
> > to add, update and delete. The wizard fails with an error message "There
> > were
> > errors configuring the data adapter". I do not understand how Microsoft
> > can
> > provide the ability to have 200+ fields in Access or SQL and not support
> > them
> > with ADO that they have been highly promoting. I never had a problem with
> > DAO
> > using VB6. What's up! frustrated with .net
>
>
>

Relevant Pages

  • Re: Database Design
    ... Storing PDF files, Cad Files, ect..ect.. ... Microsoft IT Academy Program Mentor ... either work by linking to the data or storing it in the database itself. ... One other thing I would like to accomplish would be to have the ability to ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Database Design
    ... Microsoft IT Academy Program Mentor ... build a database where I can store all this info in one place. ... either work by linking to the data or storing it in the database itself. ... One other thing I would like to accomplish would be to have the ability to ...
    (microsoft.public.access.tablesdbdesign)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • Performance optimization vs satisficing (was Language Oriented Programming)
    ... >machines that were too small. ... Microsoft has been a leading offender here. ... >arcane issue for server engines. ... magnitude slower, yes, I recall working on a 200mb database, trying to ...
    (comp.object)