Teradata链接服务器在SQL 2005。

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:

我正在尝试使用SQL Server 2005中的一个链接服务器连接到Teradata。当我尝试使用SQL Server连接OPENQUERY时，我得到以下错误:

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

为链接服务器“TERADATA”报告了一个错误。拒绝访问。

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

Msg 7350，级别16，状态2，第一行无法从OLEDB提供程序“TDOLEDB.1”获取链接服务器“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.

当我“测试连接”测试成功时，但是当我尝试在SQL Server Management Studio中查看目录默认表时，我得到了相同的错误。我在运行SQL server的计算机上安装了Visual Studio(它是一个开发框)，我可以使用OLE DB驱动程序连接，我可以运行查询，并导航到Catalogs默认表。让一个链接服务器与Teradata一起工作有什么诀窍吗?如有任何建议，我们将不胜感激。

--CDW

——车损险

3 个解决方案

#1

Hopefully these will help:

希望这些能够帮助:

TeraData Forums

TeraData论坛

TERADATA ADVISORY GROUP SETS BEST PRACTICES FOR BUSINESS OBJECTS AND TERADATA CUSTOMERS

TERADATA咨询集团为业务对象和TERADATA客户设置最佳实践

Best Practices for Teradata Deployments

Teradata部署的最佳实践

Teradata Developer Exchange

Teradata开发人员交流

#2

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

你能从DBC中选择吗?与正在连接的用户的表视图为?

SELECT * from DBC.TablesVX

#3

you might try...

你可以试一试……

http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/cbefb8c9-57e5-48d6-9c47-dc797bbf444b

where Brian says "Setting the TODLEDB.1 provider properties in SQL Server Management Studio to “allow inprocess” worked in overcoming this type of issue."

Brian说:“在SQL Server Management Studio中设置TODLEDB.1提供程序属性，以允许inprocess解决这类问题。”

regards

问候

zdba

#1