请问linux版本的sqlsersver,服务器链接怎么链接oracle?

HAN WU 41 Reputation points
2022-11-11T07:55:05.41+00:00

请问linux版本的sqlsersver,链接服务器怎么链接oracle?

SQL Server | Other
{count} votes

1 answer

Sort by: Most helpful
  1. PandaPan-MSFT 1,931 Reputation points
    2022-11-14T02:04:12.487+00:00

    Hi @HAN WU ,
    First, you need to download the ODAC Runtime Downloads from this link: https://www.oracle.com/technetwork/topics/dotnet/downloads/odacdeploy-4242173.html
    The second step. run the CMD as administator and run : install.bat oledb c:\oracle odac
    The third step, in the system environment variable, add "C: \ oracle C: \ oracle \ bin" to the Path first and restart your SQL Server.
    The fourth step, you got the 259899-image.png and pls set the Allow in-process, in the propertites.
    The fifth step,259879-image.png choose this choice.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.