Error while processing a cube :(

I am getting the following error when trying to process my cube. Can someone
please guide as to how this problem can be solved. Thanks
Data source provider error: [Microsoft][ODBC SQL Server Driver][
SQL Server]Cannot resolve collation conflict for equal to operation.;37000;
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...When you process the cube you can see the query that olap is using to
retrieve data from SQL.
If you have a look at that query he is going to match several fields to each
other. In one of the fields you have a collation problem. You try to match
2 field together with a different collation.
You will have to check the collation settings of these fields.
Regards,
Nico
"Learner" wrote:

> I am getting the following error when trying to process my cube. Can someo
ne please guide as to how this problem can be solved. Thanks
> Data source provider error: [Microsoft][ODBC SQL Server Driver]
1;SQL Server]Cannot resolve collation conflict for equal to operation.;37000
;
> ****************************************
******************************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NE
T resources...
>|||Tons of thanks Nico.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...