SqlDataAdapter issue

[Tom Wing]

I recently replaced MSDE with Sql Server 2005 Express. Now, when using the Data Adapter Configuration Wizard (VB.Net 2003) and only one table, only the Select command is generated. The wizard indicates that there are (unspecified) errors preventing the generation of the Update/Insert/Delete commands.

Can anyone shed light on this? Thanks.

 

[DavidT_macktool]

I'll take a stab at this.
I would start by verifying the tables key(s). Make sure the table has some form of unique identifier.
Clustered keys also can present this type of problem. If you are using more than one field as a key, I suggest unchecking the box marked CREATE AS CLUSTERED.
I admit I really don't remember the functionality behind a clustered key, but I do remember unchecking it when the key is created.

 

[Tom Wing]

David,

Thanks for your suggestion. I created the database using Sql Server 2005 Express. There is a primary key - that's one of the first things I looked at. In fact, I deleted the mdb and re-created it from scratch just to be sure. It's extremely simple; only one table so there are no joins, etc. I just can't see the problem. I'm beginning to wonder about the .net installation; whether it may have been corrupted somehow, but other things seem unaffected.