Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Unique identifier error when configuring data adapter
Message
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Divers
Thread ID:
00891636
Message ID:
00891644
Vues:
29
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform