views:

476

answers:

2

I am trying to connect to Teradata using a Linked Server in SQL Server 2005. When I try to use SQL Server to connect using OPENQUERY, I get the following errors:

Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "TDOLEDB.1" for linked server "TERADATA" reported an error. Access denied.

Msg 7350, Level 16, State 2, Line 1 Cannot get the column information from OLE DB provider "TDOLEDB.1" for linked server "TERADATA".

When I "Test Connection" the test succeeds, but when I try to view the Catalog default Tables in SQL Server Management Studio, I get the same error. I have Visual Studio installed on the computer running SQL server (it is a dev box), and I can connect using the OLE DB driver and I can run my query, and navigate to the Catalogs default Tables. Is there some trick to getting a linked server to work with Teradata? Any suggestions are greatly appreciated.

--CDW

A: 

Can you select from the DBC.Tables views with the user you are connecting as?

SELECT * from DBC.TablesVX
Ted Elliott