SQL 2008連Oracle Linked Server出現Access denied
| | 0 | | ![]() |
在SQL 2008 x64 @ Win 2008 R2 x64上使用Linked Server連上Oracle,進行查詢時傳回以下錯誤:
select * from openquery(OraServerA, ‘select sysdate from dual’)
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "OraServerA" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "OraOLEDB.Oracle" for linked server "OraServerA".
之前用SQL連Oracle Linked Server的做法應用在很多地方過,沒遇到這種問題,不知是否是因為x64的關係,爬文後發現機關一處:
記得設定Allow Inprocess後要重新建立Linked Server才會生效!
Comments
Be the first to post a comment