<div>
<div class="content wysiwyg-content">
I need to use SQL Server 2005 to connect to my ORACLE database.<br />
<br />
Can someone please tell me a Step-by-Step process of how to setup. I can access Oracle using SSIS and so my assumption is that I should be able to ACCESS my Oracle DB using SQL Server MANAGEMENT STUDIO as well.... correct?<br />
<br />
Any help is greatly appreciated.
</div>
</div>


I need to use SQL Server 2005 to connect to my ORACLE database.

Can someone please tell me a Step-by-Step process of how to setup. I can access Oracle using SSIS and so my assumption is that I should be able to ACCESS my Oracle DB using SQL Server MANAGEMENT STUDIO as well.... correct?

Any help is greatly appreciated.

Need Step-by-Step process of connecting to Oracle DB using SQL Svr 2005 .NET Connection?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.