?
Solved

Tying Oracle 11g into SMSS 2012

Posted on 2013-12-30
2
Medium Priority
?
239 Views
Last Modified: 2014-01-16
Is there a means to query a Oracle 11 database from SMSS 2012?

Thanks
0
Comment
Question by:fmi_techsupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 70

Accepted Solution

by:
Qlemo earned 750 total points
ID: 39746454
You mean SSMS? Yes, but only server-based, that is the SQL Server performs the query, and needs to be able to use the Oracle OLEDB driver (or ODBC) - via something called "Linked Server", the same feature used to query other SQL Server instances. The client is not involved in the connection.
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 39746823
hi

take a look at this guide from Sql Server mag on connecting to Oracle
using linked server

Connecting SQL Server and Oracle Using Linked Servers
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question