Errors configuring the data adapter

  • Thread starter Thread starter Rob Richardson
  • Start date Start date
R

Rob Richardson

Greetings!

I am trying to set up an SQLDataAdapter to talk to a simple table in my
database. I have successfully created an SQLConnection object and another
SQLDataAdapter to talk to a different table. The table I am trying to use
the second adapter for has three columns, a uniqueidentifier column set up
to be a primary key, a 10-character char column named formula_cde, and a
50-character char column named comonent_fk. No columns can be null. That's
all there is to it. In the data wizard, I select the query builder, select
my table, and select All Fields (the asterisk). When I click Next, I get a
window reporting that the update and delete queries could not be generated
because "there were errors configuring the data adapter". There is no
indication of what the errors are.

I tried deleting and rebuilding the table, but got the same result.

I've found a couple of references on this newsgroup to this problem, but no
suggestions on how to resolve it were posted. There was nothing about in
the MS Knowledge Base, either. In the help files, it said that there would
typically be an additional error message. There wasn't.

Has anybody found what this error really means?

Thanks very much!

Rob
 
Hi Rob,

A lot of us do not use the wizards anymore.
However we did and therefore I have to do a lot from memory.

The best thing to try in my opinion is creating a new project and try to do
the same thing with that new addapter you are doing now.

I remember me that often things where staying in the code when you deleted
things from the wizard. (It is not a big problem if you know what it is, but
untill that time I know what a hell it is).

I hope this helps,

Cor
 
Cor,

Thanks for your reply. In my brief time with VB .Net, I'm starting to get
the same impression.

Rob
 
Back
Top