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.
"sf2005" <(E-Mail Removed)> wrote in message
news:uLp5%(E-Mail Removed)...
> 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
>
>
>

The datasets that I am currently trying to create are viewing one table, not
multiple.



"W.G. Ryan MVP" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:uLp5%(E-Mail Removed)...
>> 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
>>
>>
>>
>
>

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


"Cor Ligthert [MVP]" <(E-Mail Removed)> wrote in message
news:O$(E-Mail Removed)...
> SF2005
>
> Just a guess, can it be that you use reserved words in your datanames or
> whatever?
>
> Cor
>

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:uLp5%(E-Mail Removed)...
>>> 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
>>>
>>>
>>>
>>
>>
>
>

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/...6ab061ceecea76


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