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

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 08:14:20 -0700

I can't speak for Microsoft. Several of their folks lurk here so perhaps
they can answer you. 

-- 
____________________________________
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.net" <ado.net@discussions.microsoft.com> wrote in message 
news:C99B0424-4AD1-463A-989F-A797E1AE6AAE@microsoft.com...
> 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: 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)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Repairing / modyfing Exchange
    ... Customer Service and Support for more immediate assistance. ... This service gives you access to Microsoft technical support engineers who ... database by using the old Server's database files, ... >> up with the First Storage Group, so you would like to delete it and then ...
    (microsoft.public.windows.server.sbs)