Analysis Service & Teradata - The provider 'TDOLEDB.1' is not registered.

Connectivity

Analysis Service & Teradata - The provider 'TDOLEDB.1' is not registered.

Hi, I am able to create the cubes using the TDOLEDB provider in Analysis Service and only come across the following error when processing the cubes. "The provider 'TDOLEDB.1' is not registered."



I am running the following configurations

- Windows 7

- Database: Teradata 14.00.03.02 on VMware

- Analysis Service - SQL Server 2012 64 bit

- Teradata ODBC Driver Version      14000004

- TDOLEDB provider           WINDOWS_i386.14.00.00.01



The issue is surrounding the 32bit TDOLEDB provider (Teradata only offers a 32-bit OLEDB Provider) conflicting with the 64 bit SQL Server 2012. I am able to get the cube to processing if I modify the Data Source connection string and use the .NET Providers for Teradata which is a 32/64 bit.



Am I correct to make the above assumption or is there a work around that I can do and get it to work with the 32 bit TDOLEDB provider?

2 REPLIES
Enthusiast

Re: Analysis Service & Teradata - The provider 'TDOLEDB.1' is not registered.

Hi, any luck on this.

 

Having same problem ("provider not registered")

Teradata Employee

Re: Analysis Service & Teradata - The provider 'TDOLEDB.1' is not registered.

You are correct.

TDOLEDB provider for Teradata is only 32-bit version, there is no 64-bit version.