For certain SQL's I will get the following error when calling the Fill method on an AdomdDataAdapter object.
"Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed."
Snippet of Code:
DataSet ds1 = new DataSet();
AdomdCommand acmd1 = cn1.CreateCommand();
acmd1.CommandText = "SELECT ...";
AdomdDataAdapter ad1 = new AdomdDataAdapter(acmd1);
Now when we run this query in Ms Sql Studio we don't get any errors but the query returns 1 row with over 40,000 columns. I'm guessing the # of columns might be an issue but not sure.
When doing a Google search it appears that this problem was found in the 2005 and fixed in that version. Have any of you come across this problem?
View Complete Post