Hi,

I've created a relational group of tables using the designer for the Data
Adapter. It decided to cross join all the tables, so I manually did it using
Inner joins, nothing special just PK to FK.

When I click preview data, then try to fill a dataset created by the
Generate Dataset button of the DataAdapter, I get the following error:

"The data adapter could not return the data from the data source."

"Syntax error converting the varchar value 'myStringValue' to a column of
data type int".

When I look at the schema of the Dataset, all the columns are varchar.
Why is it doing this?

Any suggestions/past experiences very welcome & thanks in advance.

Ant