Visual Studio DataAdapter Wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am exploring the possibility of creating a data transforation program that
uses an Access Database with some fairly large table schemas.

Although Access has no problem with tables containing a large number of
fields the Data Adapter in Visual Studio 2003 does.

If I try to use the Wizard to configure the adapter I get an error. If I
select the fields progressively in sets of say 5 the Wizard completes its
task until some unknown limit is reached. Could it be simply that the
generated SQL Select, Update, Delete string statements are too long, or do we
have a bug? How can I work around this problem? The table schemas are from
another third party product.
 
I estimate that the record I am dealing with is about 2,300 bytes in 160
fields of various types. If I look at the code that the wizard generated for
the DataAdapter I see:
this.oleDbSelectCommand2.CommandText = "select [ar_invoice].* from
[ar_invoice];

In the above the DataAdapter is labeled oleDbDataAdapyter2 and the table is
named ar_invoice.

The select statement is very unusual because the Wizard generated select
statement is usually exanded into enumerated field names but for some reason
in this case it is truncated with a wild card. I have never seen this before.
The wizard then terminates without completing the generation of add delete
and amend functions.

Perhaps the problem lies in the wild card treatment of the data fields but
this is not a controllable process. This is in doubt however because if I use
the query builder option of the Data Adapter Wizard to select eacg field by
name and build an expanded select statement I can only include the first 24
fields before the same error occurs. The wizard just doesn,t seem to have the
capacity to handle this size of schema.

Any ideas?
 
Back
Top