>Did you see this http://weblogs.asp.net/rosherove/archive/2004/10/03/DataSet-hell-_2D00_-_2200_Failed-to-enable-constraints.-One-or-more-rows--contain-values_2E002E002E002E002200_.aspx
>
>In particular, it sounds like you may try to set .EnforceConstraints to false according to this message.
>
>Read also through all the comments if the above would not resolve the issue. There are several other useful suggestions in this blog.

Thanks, this looks like another setting that could be in effect with the SQLClient provider. In the other thread, because of the readonly column, I had to set a setting. This looks pretty much the same here. I'll have more time on this on Thursday. I'll keep you inform about what I find.