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

  • Thread starter Thread starter sf2005
  • Start date Start date
S

sf2005

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
 
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.
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
SF2005

Just a guess, can it be that you use reserved words in your datanames or
whatever?

Cor
 
I don't believe so. I am getting the error on all of the tables. Below are
the table structures of some of the smaller tables.

field / type / size
pk = primary key, fk = foreign key

status Table
statusid / integer / / pk
status / char / 35

category Table
categoryid / integer / / pk
category / 30

problemtype Table
probtypeid / integer / / pk
categoryid / integer / / fk
probtype / char(35)

swatech Table
swatechid / integer / / pk
swatech / char / 30
employeenumber / integer
helpdeskid / char / 15
hphone / char / 15
birthday / char / 5
termd / char / 1
homeemial / char / 50
mgr / char / 1
misdeptid / integer / / fk
 
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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
OK...

Going back over the 3 databases I was using as tests, I found that the SQL
Server DB table that was created did hold the primary key that I set. I set
the primary key, and now for the SQL server table I am NOT getting the data
adapter configuration error message anymore.

But, I need or would like to get it working for Informix, because they would
like for me to move the existing Access database preferable to Informix due
to inhouse support I would have (I'm new to informix and SQL Server as well
as VB .NET, ADO .Net, and ASP.Net ). My brain is beyond full! I checked
the Informix tables for primary keys and they ARE there, but still getting
the error. I also checked the web and found when using ADO .Net and the
Informix OLE DB Provider, the developer must specify their own update/delete
commands manually in code. The wizard will not generate them for Informix.

See:
http://groups-beta.google.com/group...fy+the+rows+for&rnum=9&hl=en#fa6ab061ceecea76


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]"
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]"
 
Back
Top