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

The datasets that I am currently trying to create are viewing one table, not
multiple. This is happening on all tables that I try to create a dataset
for. I attached the structure of one of the tables, in case some asked
about primary key or the table structure.

"W.G. Ryan MVP" <WilliamRyan@xxxxxxxxxxxxxxxx> wrote in message
news:uecYuqloFHA.2156@xxxxxxxxxxxxxxxxxxxxxxx
> When you say 'one of the table structures' are there more than one table
> in this qeury? If so, that's the problem. If you want the autoconfig
> tools to work, joins aren't supported for anything other than select
> statements.
> "sf2005" <sf2005@xxxxxxxxx> wrote in message
> news:uLp5%23gloFHA.3408@xxxxxxxxxxxxxxxxxxxxxxx
>> 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: 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: 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)
  • Re: Could not determine which columns uniquely identify the rows for [Table Name]
    ... >>> I am in the process of migrating our MS Access Database to Informix ... My test database is on a Linux box (Informix Dynamic server is ... >>> Data Adapter Configuration Error... ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Incorrect ID returned
    ... update method of a dataadapter to get them posted back to the SQL ... The Update and Insert commands on a data adapter will not know the values the remote database used due to triggers, ... unless you query that data from the server. ... This tells the data adapter that the first record returned by the update/insert script should be considered as values the database stored, ...
    (microsoft.public.dotnet.framework.adonet)