Cube Processing Error - OLE DB error: OLE DB or ODBC error: Class not registered.

Problem

I get the above error when trying to process the cube.

Environment

Server OS - Windows 2003 64Bit

SQL Server 2005 64Bit

Database - Teradata

Connectivity - OLE DB for Teradata

Testing

- Have successfully tested OLE DB connectivity using Hyperion, connecting using an OLE DB Connection file.

- Get the same error when trying to process a sample MS Access database or Teradata

- Uninstalled and reinstalled SQL Server 2005

If anyone has any idea’s it would be greatly appreciated, thanks.

It might be that the provider (in the connection string of the datasource) is set to the 32bit version (if you used BI Development Studio or SQL Management Studio on a client 32bit machine). Then you deploy and, during processing, the AS2005 server tries to instantiate the provider and fails (because you have the 64bit version of the provider installed on the server machine).

Adrian

|||

Thanks,

I used Visual Studio 2005 to develop a Test Cube on the Server after the installation.

Back Ground

I originally installed SQL Server 2005 using a Local Account but it was then decided that it was best done under a Domain account (Up until this point I could process AS2005 cubes). So I uninstalled SQL Server 2005 and reinstalled using the domain account.

I think somewhere along the way a Registry File has become corrupt. Is there any way to test this?

Next Step

If I am unable to resolve this issue I will re-image the server and hopefully this will remove any corrupt Registry files.

Any other Idea's?

Thanks