DataAdapter: Maximum length SQL statement?

15 Feb 2006 8:47 PM

DjMark

Hi,

I am trying to configure a dataAdapter in Visual Studio 2003, using the
wizard.
I tried using the SQL statement, "SELECT * FROM table"
When i preview the output in de Query builder everything seems to work fine.
But when i finish the wizard, i get an error: "There were errors generating
the dataadapter".
So i started adding the table fields one by one, and it kept working fine,
until i added about the 50th field, after that the error appeared again.
So to me it seems there is a maximum in the amount of fields you can add to
a dataadapter.
Maybe alot of fields cause the wizard to create a SQL statement(Select or
Update) wich is too long.

Anyone who knows anything about this?

16 Feb 2006 2:34 AM

Val Mazur (MVP)

Hi,

I believe it is an issue with the wizard, not with the DataAdapter itself.
Try to create it using code, not a wizard

--
Val Mazur
Microsoft MVP
http://xport.mvps.org

Show quote

"DjMark" <DjM***@discussions.microsoft.com> wrote in message
news:9AAB57A1-03FA-4E42-BDAF-80EECD3F5623@microsoft.com...
> Hi,
>
> I am trying to configure a dataAdapter in Visual Studio 2003, using the
> wizard.
> I tried using the SQL statement, "SELECT * FROM table"
> When i preview the output in de Query builder everything seems to work
> fine.
> But when i finish the wizard, i get an error: "There were errors
> generating
> the dataadapter".
> So i started adding the table fields one by one, and it kept working fine,
> until i added about the 50th field, after that the error appeared again.
> So to me it seems there is a maximum in the amount of fields you can add
> to
> a dataadapter.
> Maybe alot of fields cause the wizard to create a SQL statement(Select or
> Update) wich is too long.
>
> Anyone who knows anything about this?
>