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

Ok, that's the most likely culprit but it's not the case here. Just as an
FYI...The dataset itself doesn't have any bearing on this errror - it's
related to the tabe in the database. Let me look through the rest of your
post though and look around, I'll post back shortly.
"sf2005" <sf2005@xxxxxxxxx> wrote in message
news:%23fmpj2loFHA.3304@xxxxxxxxxxxxxxxxxxxxxxx
> 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]
    ... SQL Server 2000 or Linux ... >> I am in the process of migrating our MS Access Database to Informix ... >> 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)