mssql express 2005链接服务器无效的对象名称(mssql express 2005 linked server Invalid object name)

mssql express 2005链接服务器无效的对象名称(mssql express 2005 linked server Invalid object name)

我使用此站点中的第一篇文章创建了链接服务器： http ： //www.sqlservercentral.com/Forums/Topic340912-146-1.aspx但我无法继续工作5.更改提供程序MSDASQL的属性。没有右键单击MSDASQL中的属性。 我想清除缓存，但没有Edit-> IntelliSense或Tools >> Options >> Text Editor >> Transact-SQL。 我正在使用SSMS Express 2005并连接Windows身份验证。 我正在尝试这个链接服务器查询：从[MYSQLAPP] .databaseName.tableName中选择*，我得到无效对象名称'MYSQLAPP.databaseName.tableName'。 不知道该怎么办。 经过几个小时的搜索，我疯了。

I have created linked server using first post in this site: http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx But I cannot work on from 5. Change the Properties of the Provider MSDASQL .There is no such thing as Properties in Right Click MSDASQL. I wanted to clear cache, but there is no such thing as Edit->IntelliSense or Tools >> Options >> Text Editor >> Transact-SQL. I am using SSMS Express 2005 and connecting with windows authentication. I am trying this linked server query: select * from [MYSQLAPP].databaseName.tableName and I get Invalid object name 'MYSQLAPP.databaseName.tableName '. Dont know what to do. I am going mad after hours of search.

最满意答案

如果其他人正在努力回答我应该使用：SELECT * FROM OPENQUERY（MYSQLAPP，'SELECT * FROM databasename.tablename'）

If someone else is struggling answer is I should use: SELECT * FROM OPENQUERY(MYSQLAPP, 'SELECT * FROM databasename.tablename')