Failed To open Rowset 1

[ganjass]

Hi ALL

I'm connecting to a SQL 2000 database through CR10. The report in question has been working fine until the last week where i am getting the following e\m, i cannot find any definition of this precise error any ideas??

"Failed to open rowset.
Details: 42000:[Miscrosoft][ODBC SQL Server Driver][SQL Server]Cannot sort a row of size 9313, which is greater then the allowable maxium of 8094."

 

[MColeman]

If the SQL error does not have an ODBC error code to map to, the SQL Server ODBC will return error number 42000. This is a 'generic' error number meaning there is a syntax error or access violation in the SQL.

SQL has a limit to the size of the row it can sort. Has a large record been added to your table?

Do you have memo fields in the table that have gotten filled with a large amount of data?