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

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: "Could not determine which columns uniquely identify the rows for tablename"
    ... > I am in the process of migrating our MS Access Database to Informix ... > ready yet), but I have tried the below on the Linux Server, SQL Server ... > Data Adapter Configuration Error... ...
    (microsoft.public.vb.database.ado)
  • Re: Informix connection to SQL Server
    ... Unless of course the ODBC stuff doesn't ship ... with IDS on Linux ... Informix connection to SQL Server ...
    (comp.databases.informix)
  • RE: Infomix test databases for migration to SQL Server - please help
    ... A lot of us are fighting really strong for Informix. ... from MySQL to SQL Server, I would probably go to the SQL Server forum and ... Infomix test databases for migration to SQL Server - please ...
    (comp.databases.informix)
  • SSIS Bug ?? "Column xxx cannot convet between unicode and non-unicode string data types"
    ... Using Sql Server 2005 on a Win2003 Ent server. ... Starting on an SSIS project to move data directly from Informix tables to ... When moving Informix char/varchar columns to the matching Sql Server 2005 ... Server Destination" data flow destination object to throw the following ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server on Linux - reality!!!!
    ... Who really with all of the choices available on Linux. ... My sources at Microsoft put out the word late yesterday that there is a project underway to port SQL Server to Linux!! ... SQL Server, however, is a true platform that doesn't need a client to run against. ... Given that many different sources need a high quality ETL engine, and a SQL Server license to handle this is still cheaper than IBM's Information Integration product and most other tools, there's hope that Integration Services will provide the foothold into Linux. ...
    (borland.public.delphi.non-technical)