[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

Tying Oracle 11g into SMSS 2012

Is there a means to query a Oracle 11 database from SMSS 2012?

Thanks
0
fmi_techsupport
Asked:
fmi_techsupport
1 Solution
 
QlemoDeveloperCommented:
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
 
Aaron ShiloChief Database ArchitectCommented:
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

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now