How to create oracle linked server in SQL Server

[@KaiWenFranklin]

Worked just fine! THANK YOU!!!

[@redincs]

Great to hear!

[@kmaywfec]

Thank you so much!! I'm an Oracle guy and SQL Server drives me crazy. This video showed me exactly what I needed.

[@redincs]

You're welcome!

[@5t1300]

This is exactly what I needed! Thank you for the clear instructions :)

[@redincs]

You are so welcome!

[@milestomemoriez]

Thank you so much! It worked seamlessly, i was struggling with Oracle installation for linked server with sql.

[@redincs]

You're welcome!

[@Fenrir6668]

Been chasing myself in circles for two weeks trying to find the right ODAC version to use, didn't even think of downloading the full client. Thank you for showing the cloud download offerings.

[@redincs]

Glad I could help

[@sebadigiorgio1770]

A genius!!!! Thank you!

[@redincs]

thank you!

[@benjisamuel2399]

thank you so much my friend you did an amazing work. I have been trying to figure out this for hours because i installed the oracle client 11 g 32 bits and my sql server is 2022 tnsping worked by the ssms was not able to see the oracle provided. I followed lot of different pages. at the end I saw your video which saved me. thanks again for saving my day you are genius. God bless you.!!

[@redincs]

Thank you for you comment, I appreciate it!

[@rowlandjones3872]

GREAT CONTENT...!!!

[@redincs]

Thank you!

[@yalcinaksan]

Thank you for your clean explanation 👍

[@redincs]

You’re welcome

[@xLuisGabriel1998x]

Thank you!!! Helped me a lot.

[@redincs]

You're welcome!

[@duanjoe]

It worked for me. Very helpful. Thank you.

[@redincs]

Excellent!!

[@madhuk873]

Linked server test connection working fine but, while expading tables in linked server getting below. Error. Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE_testlinked". The provider supports the interface, but returns a failure code when it is used. (Microsoft SQL Server, Error: 7311)

[@ziadfawzi]

Thank you so much.

[@redincs]

You're welcome!

[@dataanalyst839]

We mad a successful connection from SQL Server to Oracle, but the only thing is that need to use openquery t-sql function each time. Is there any way to query tables without it?

[@redincs]

You’d need to rewrite the query

[@dataanalyst839]

@redincs how? Provide example.

[@TalhaIftikhar-wj3bu]

what if we have rds oracle instance?

[@emarversity]

The process is the same.

[@rowlandjones3872]

HOW DO WE GET CONTENT FROM A VIEW RATHER INSTEAD OF TABLE

[@redincs]

Yes you can

[@TheEminn26]

thank u :))

[@redincs]

You're welcome 😊

[@sebadigiorgio1770]

I had to replace (SID =DEV) with (SERVICE_NAME = your service name)