how to link TD to SQL Server using OLE DB Provider?


how to link TD to SQL Server using OLE DB Provider?

I am trying to link a SQL Server to TD using OLE DB Provider. The TD is the Datawarehouse, holds the source of truth and the SQL Server runs a small application. I downloaded and installed the latest TD OLE DB drivers on the SQL Server box.

I failed to make the link statement work:

EXEC sp_addlinkedserver
@server = 'GDW',
@provider = 'TDOLEDB',
@srvproduct = 'OLE DB Provider for Teradata',
@provstr = 'Data Source=;User ID=USERID;Password=UserPswd;Default Database=ADB;Extended Properties=""Session Mode=ANSI;Enable P****r=NO;"";'

I received both of the following select statements

SELECT * FROM OPENQUERY(GDW, 'select count(*) AS countAll from ..ADB.aTable')

select count(*) from GDW..ADB.aTable

I received the error :

Could not initialize data source object of OLE DB provider 'TDOLEDB'.
OLE DB error trace [OLE/DB Provider 'TDOLEDB' IDBInitialize::Initialize returned 0x80040e21].

I achived a success, I succesfuly run the next statement:

'Data Source=;User ID=USERID;Password=UserPswd;Default Database=ADB;Extended Properties="Session Mode=ANSI;Enable P****r=NO;";'

Teradata, Google and Yahoo searches returned ZERO results for
sp_addlinkedserver TDOLEDB

Thanks in advance for any help.


The forum substitutes Enable P a r s e r=NO with ***'s :-(