Q: During database processing I am getting error "OLE DB error: OLE DB or ODBC error: Class not registered"

Written by webadmin. Posted in Management FAQ

Q: After SSAS 2005 to 2008 migration, during database processing I am getting errors:

OLE DB error: OLE DB or ODBC error: Class not registered
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of myDataSource', Name of 'myDataSource'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of DimensionID, Name of 'DimensionID' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'DimensionID' attribute of the 'DimensionID' dimension from the 'SSASDBName' database was being processed.

A: In your SSAS project data source folder check provider. To do that double click on your data source and then in the General tab click on the button "Edit...". At the very top you will see Provider value. If it is "Native OLE DB\SQL Native Client", then you need to change it by selecting "Native OLE DB\SQL Server Native Client 10.0". After that your data source connection string will change from "Provider=SQLNCLI.1;" to "Provider=SQLNCLI10.1;...". This change should fix above reported error.

Now you should re-deploy your SSAS database and try to process it again.