Solved

Tying Oracle 11g into SMSS 2012

Posted on 2013-12-30
2
235 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
2 Comments
 
LVL 69

Accepted Solution

by:
Qlemo earned 250 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql help 8 58
export sql results to csv 6 40
Text file into sql server 5 32
Need help with a Stored Proc on Sql Server 2012 4 28
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

828 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