Microsoft small business knowledge base

Article ID: 327239 - Last Review: November 2, 2013 - Revision: 2.0

This article was previously published under Q327239
This article has been archived. It is offered "as is" and will no longer be updated.


When you try to perform a drillthrough query or retrieve data from a writeback operation by using a Microsoft SQL Server database as the relational source, you may receive the following error message:
Data source provider error. Statement(s) could not be prepared.;42000;Cannot resolve collation conflict for equal to operation.;42000 An error occurred during attempt to get cell value.

The error message may occur if the collation sequence between the tempdb database is different from the user database that is used as the OLAP data source.

More information

This known issue occurs when the collation sequence between the tempdb database and the user databases is different. When you run a drillthrough query or a query against a writeback table, the number of parameters that are passed in the query is evaluated. If the number of parameters exceeds 2,000, a temporary table is created in the tempdb database, and the query is split. Because the tempdb database is built every time that SQL Server starts, the default collation for the tempdb database is the same collation that is used for the model database. In situations where the collation sequence between the tempdb database and the user database is different, the temporary tables that are created and stored in the tempdb database have collations that are different from similar objects that are created in permanent tables.


For more information, see the "Mixed Collation Environments" topic in SQL Server Books Online.

Applies to
  • Microsoft SQL Server 2000 Analysis Services
kbnosurvey kbarchive kbinfo KB327239
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support