I keep getting this error on SQL Compact Server 3.5 whenever I try to do a RDA.Push() on this particular table. The error I get is "insufficient result space to convert uniqueidentifier value to char". The error code is 8170.
Google search says that setting the column size to bigger value would fix the issue, but this is a simple push of the data.
the table structure is as follows: TABLE tblAQC ( AQCAnswerSetID UniqueIdentifier NOT NULL, AQCQuestionID INTEGER NOT NULL, AQCCategoryID INTEGER NOT NULL, AQCAnsText VARCHAR(30) NULL, PRIMARY KEY(AQCQuestionID, AQCCategoryID, AQCAnswerSetID) );
The funny part is that I am trying to push another table to the main database and that's working absolutely fine even though it has got two data columns of type "uniqueidentifier". Even earlier also, all other tables have been working fine.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.