Solved

Tying Oracle 11g into SMSS 2012

Posted on 2013-12-30
2
232 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 68

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Query 3 48
Upgrading Integration Services 3 28
SQL profiler equivalent in MS-Access 3 42
Generate Weekly Schedule 15 15
Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
In this article I will describe the Detach & Attach 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.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

910 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now