Quote Originally Posted by cokelite
For cjard's information:

The DataSet is generated from SqlServer and is written to SolidServer.

For JonnyPoet:
The resulting CommandText seems to be valid.
"INSERT INTO TableX(Field1, Field2, Field3 ) VALUES ( ? , ? , ?)"

(connConnection, trans); // whats this ? That was a typo in my post, sorry.
Trerrornummber 7007 says that the number of fields is incorrect so have you added all parameters correctly ? or are there fields missing which needs to get data ( must be written ) and you havn't inserted their data? I would look for nummber of fileds needed to insert and if all the data in the params are available