如何使用查询从链接的服务器获取数据 [英] 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屋！