Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unique identifier error when configuring data adapter
Message
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00891636
Message ID:
00891644
Views:
30
This message has been marked as a message which has helped to the initial question of the thread.
Hi Todd,

You will not be able to do this for VFP because of a bug in VS.NET for OleDb providers. However, for SQL Server, this can be caused when your table doesn't have a primary key or your database has a "." in the name. If that doesn't explain it for you then try using Northwind in SQL Server and make sure it works there.

>Greetings,
>
>Im creating a .Net Windows Form. When attempting to drag and drop a table from either VFP or SQL Server 2000 on to the form I get the error:
>
>Problem configuring data adapter Update and Delete statements: Could not determine which columns uniquely identify the rows for "mytablename"
>
>I first got the error when attempting to attach the form to VFP data so I thought the vfpoledb provider was unable to identify the primary key in my table so I updated the provider. Then discovered the same problem when connecting to a SQL server table.
>
>Not sure what it needs...
>
>Todd
-----------------------------------------

Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.com
www.prenia.com
Weblog: blogs.prenia.com/cathi
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform