Errors in the high-level relational engine. when building cube with DSV with two different data

I get the following error when trying to build a cube when the measures are created from a data source view with two data sources both SQL Server 2000.

There error is:
Errors in the high-level relational engine. The following
exception occurred while the managed IDbCommand interface
was being used: Could not locate registry entry for OLE DB
provider 'SQLNCLI.1'..

The SQL executed looks like:
FROM
OPENROWSET
(
N'SQLNCLI.1',
N'',

The cube builds fine if the measure is not added from the secondary source, once added it fails to build. You can view the secondary datasource in the Data Source view fine and in the Cube Structure table diagram.

[822 byte] By [MichaelP] at [2008-3-1]
# 1
I was able to eliminate the same error by specifying the OLEDB provier for SQL Server, instead of the newer SQL Native Client, for connections to SQL Server 2000.
mksql at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Analysis Services...

SQL Server

Site Classified