Linked server configuration sql server management studio to Oracle Database

I'm goging to explain how to connect oracle database using sql server management studio

follow below process -

Control Panel -> Administrative Tools -> Click on ODBC data sources(64)

Click on system DSN tab and click on Add button then window will be open As 

Here select Oracle in OraClient11g_Home1 and click on finish button then window will open As-

Here if you will not get OraClient11g_Home1 then click on this Link

Here provide your Oracle database details and Data Source Name as above

Click on test Connection Button then window will be open As-

Provide oracle database password and click on OK button then message will show Connection Successful.

Process to Connect with Sql server management Studio

Open management studio and Login then window will show As –

Here Click on Server Object -> Right Click on Linked Server -> Click on New Linked Server then window will open As-

Linked Server -> Enter Name  as I have Enter MMS

Provider -> select Microsoft OLEDB Provider for ODBC Driver

Product Name -> Here Specify Any Name I have specify MMS

Data Source -> Here Enter Data source Name Same as created Above

Now Click on Security Tab then window will open As-

Here check radio button as above screen

Provide Oracle User Id and password and click on ok button

Your linked server will be created.

Leave a Comment