Could not determine which columns uniquely identify the rows for [Table Name]

Visual Studio .Net 2003 / VB .Net
Database: Informix SE, SQL Server 2000 or Linux


I am in the process of migrating our MS Access Database to Informix Dynamic
Server. My test database is on a Linux box (Informix Dynamic server is not
ready yet), but I have tried the below on the Linux Server, SQL Server 2000
and Informix SE and all return the same message when I drag a table from any
of the databases on to a Windows or Web Form or the data adapter wizard from
the data tab of the toolbox on to a windows or web form.

Data Adapter Configuration Error...
The wizard detect the following problems when configuring the data adapter
for category.
Details:
* Generated SELECT statement
* Generated table mappings
* Generated INSERT statement
? Generated UPDATE Statement "Could not determine which columns uniquely
identify the rows for the [TableName]"
? Generate DELETE statment. "Could not determine which columns uniquely
identify the rows for the [TableName]"


Connect using...
- Informix SE: Microsoft OLE DB Provider for ODBC Drivers
- Linux: IBM Informix OLE DB Provider
- SQL Server: Microsoft OLE DB Provider for SQL Server

One of the table structures...
Table: status
fieldname / type / size
statusid / integer / 4
status / text / 35

statusid is the primary key



Thanks for any assistance.
sf



.

Relevant Pages

  • Re: DBIx::DBH - Perl extension for simplifying database connectio ns
    ... Only one of the Informix notations has a host name in it, ... that's technically not a host name but a server name - the distinction ... under the illusion that people who use Perl to access a database know ... The connection string is system-specific -- end of sob story. ...
    (perl.dbi.users)
  • Re: Assistance with getting DB memory usage over 2 gigs
    ... for increased performance of database servers, ... major Linux platforms. ... The Linux platforms supported by the new IBM Informix Dynamic Server ...
    (comp.databases.informix)
  • Re: How to access idx+dat informix files
    ... it's an Informix 7.2 database. ... It's not possible to unload those files from the original server ... There are several classes of Informix database products (CISAM; SE; ...
    (comp.databases.informix)
  • Re: Hardware Recommendation
    ... I would suggest you go to the various Linux sites, the ones with the distributions, and look at their hardware compatibility list. ... I would also check with the folks at Informix to find what platform would make your database fly. ... You could have a transaction by transaction backup to the NAS so you can replay the transactions should the server fail. ...
    (comp.databases.informix)
  • RE: isa server
    ... Are you using specific Locale settings for your database? ... Subject: isa server ... Using "Specify local informix servers" step in the browser i configured ... Bu e-posta mesaji kisiye ozel olup, ...
    (comp.databases.informix)