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

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

how to link TD to SQL Server using OLE DB...

Rate Topic

Display Mode

Topic Options

Author

Message

todorp

Posted 8/24/2006 7:19:52 PM

Forum Newbie

Group: Forum Members
Last Login: 9/25/2006 12:29:00 AM
Posts: 1, Visits: 1

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=10.25.111.183;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:

SELECT aField_N
FROM OPENDATASOURCE(
'TDOLEDB',
'Data Source=10.25.111.183;User ID=USERID;Password=UserPswd;Default Database=ADB;Extended Properties="Session Mode=ANSI;Enable P****r=NO;";'
)..ADB.aTable

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

Thanks in advance for any help.

PS

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

cheers

todorp

Post #4977

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 1 ( 1 guest, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 8:05am