Configuring Linked Server in SQL Server to connect to Oracle database

This tutorial is about creating database linked server in Microsoft SQL Server 2014 to connect to Oracle Database XE. You require to install Oracle instant client and configure net service name to use as data source. Example of executing dml script is mentioned in this video.

[segicus]

Thanks!, it worked for me on the latest version of Microsoft SSMS to connect to Oracle database

[AlSherman]

Thanks lots - was very helpful to me - solved my problem! :)

[AlmutasimAlmazidi]

Thank you so much, it was helpful explanation, Could you please explain the opposite how to make a link database from oracle to SQL Server

[attention]

Great video! Would you have a list of setup required for this to work? I'm trying to set up a linked server to connect to Oracle but struggle with all of the configurations as I started from nothing.
First thing to do of course is to install oracle database on the same machine but what else needs to be installed before you can perform steps in you video?

[RenzoCaceresRossi]

Good video, I have some questions, Can I install SQL Server 2012 and Oracle Databse Express 11 g in the computer? I already did but SQL Server goes all wrong, I can´t connect to the database server in the meantime Oracle works just fine

[dpdhamal]

Hi Thank you so much for this video. I am trying to connect my Oracle DB thru Sql server and I am getting this error - Cannot Obtain the required interface from OLE DB provider. Please help

[tanphuchong]

If i want to configuring Linked Server in SQL Server to connect to Oracle database from pc to another pc how can I do ?

[Fazable]

Experiment before you make a tutorial video. "I faced a problem then, I faced a problem that" what is this??