Data Adapter Configuration Error

[Keith Kuwatani]

I am using the ODBC .net provider against a pervasive 2000i database.

The Data Adapter successfully generates Table Mapping, Select Statement and
Insert Statement.
However, the Update and Delete Statements provide the following error:

Could not determine which columns uniquely indentify the rows for
"table_name".

Any help would be much appreciated.
Keith

 

[Alireza Kheyrollahi]

Please DO NOT tell me that you are using devil's tool: CommandBuilder!
If so, replace your command strings with proper SQL statements and DO NOT
let the dataadapter to mess it up with using commandbuilder behind the
scene. Commandbuilder is just a designing blunder.

 

[Kevin Yu [MSFT]]

Hi Keith,

It seems that you didn't set a primary key for the database table. The
CommandBuilder needs a primary key which is a unique identity of the rows
to generate the UPDATE and DELETE command. Try to add the primary key in
database.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| From: "Keith Kuwatani" <[email protected]>
| Subject: Data Adapter Configuration Error
| Date: Tue, 11 Nov 2003 15:39:20 -0800
| Lines: 13
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.dotnet.languages.vb
| NNTP-Posting-Host: adsl-63-198-220-17.dsl.snfc21.pacbell.net 63.198.220.17
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb:156035
| X-Tomcat-NG: microsoft.public.dotnet.languages.vb
|
| I am using the ODBC .net provider against a pervasive 2000i database.
|
| The Data Adapter successfully generates Table Mapping, Select Statement
and
| Insert Statement.
| However, the Update and Delete Statements provide the following error:
|
| Could not determine which columns uniquely indentify the rows for
| "table_name".
|
| Any help would be much appreciated.
| Keith
|
|
|