HomeНаука и техникаRelated VideosMore From: Subhroneel Ganguly

Configuring Linked Server in SQL Server to connect to Oracle database

25 ratings | 14389 views
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.
Html code for embedding videos on your blog
Text Comments (7)
RadespotosR (7 months ago)
Great video, thank you so much! Just one question. In case we need to connect with "SYS", oracle need us to specify "as SYSDBA". Is there a way to do this? Thanks again!
Subhroneel Ganguly (7 months ago)
If you are using sqlplus then I got command prompt and type sqlplus / as sysdba
Renzo Caceres Rossi (11 months ago)
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
Subhroneel Ganguly (11 months ago)
+Renzo Caceres Rossi All that conflict is the port. Since oracle and SQL server uses different ports so it should not be a problem. Please give me the details how you are connecting to sql server.
attention72 (1 year ago)
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?
Subhroneel Ganguly (1 year ago)
You need odbc driver for oracle and also install oracle instant client. Installing database on same machine will not help.
Al Sherman (1 year ago)
Thanks lots - was very helpful to me - solved my problem! :)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.