如何使用查询从链接的服务器获取数据 [英] How to get the data from linked servers using queries
本文介绍了如何使用查询从链接的服务器获取数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我创建了一个名为MSSQLTOMYSQL的链接服务器
现在我有一个名为hr的数据库,其中包含一个地址表。
要检索雇用数据,我会执行以下操作: br />
I have created a linkedserver as MSSQLTOMYSQL
Now I have a database called hr which contains an address table.
To retrieve employ data, I do the following:
SELECT * FROM OPENQUERY([MSSQLTOMYSQL],'SELECT * FROM hr..address')
我有错误
I have the error
OLE DB provider "MSDASQL" for linked server "MSSQLTOMYSQL" returned message "[MySQL][ODBC 3.51 Driver][mysqld-5.1.61-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.address' at line 1".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "MSDASQL" for linked server "MSSQLTOMYSQL".
所以请告诉我,如果有人知道它的解决方案
so pls let me know if some one know solution of it
推荐答案
嗨Arjun,>
试试这个....
Hi Arjun,
Try this....
SELECT * FROM MSSQLTOMYSQL.HR.DBO.ADDRESS
Prasad A
Prasad A
Prasad k你来回复我是从我自己解决的
下面提到的是解决方案它
Prasad k you fro reply i am solve it from my self
the below mentioned are solution of it
SELECT *
FROM OPENQUERY
(
MSSQLTOMYSQL,
'SELECT * FROM hr.address'
)
这篇关于如何使用查询从链接的服务器获取数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文