在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才會生效!


Be the first to post a comment

Post a comment