SELECT * FROM MySQL Linked Server，使用不带OpenQuery的SQL Server [英] SELECT * FROM MySQL Linked Server using SQL Server without OpenQuery

问题描述

我正在尝试使用SQL Server查询MySQL链接服务器.

I am trying to query a MySQL linked server using SQL Server.

下面的查询运行得很好.

The below query runs just fine.

SELECT * FROM OPENQUERY([Linked_Server], 'SELECT * FROM Table_Name')

是否可以在不使用OpenQuery调用的情况下运行相同的查询?

Is it possible to run the same query without using the OpenQuery call?

推荐答案

在这里找到了答案.现在，我可以查询三点符号了.谢谢

Found the answer here. Now I can the three dot notation query. Thanks

http://www.sparkalyn.com/2008/12/invalid -schema-error/

转到提供程序选项屏幕.在SQL Server 2005中，您可以在链接服务器上方的文件夹中查看提供程序列表(假设您具有适当的权限).右键单击MSDASQL并转到属性.在SQL Server 2000中，提供程序选项按钮位于创建链接服务器的对话框中. 选中仅限零级"框.

Go to the provider options screenIn SQL Server 2005 you can see the list of providers in a folder above the linked server (assuming you have appropriate permissions). Right click on MSDASQL and go to properties. In SQL Server 2000, the provider options button is in the dialog box where you create the linked server. Check the box that says "level zero only"

这篇关于SELECT * FROM MySQL Linked Server，使用不带OpenQuery的SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！