In a heterogeneous environment it sometimes becomes necessary to access information across different database. In this exercise I will demonstrate how you can access Oracle db tables in SQL Server 2005. 1. First you need to install Oracle client on the SQL server 2005 server. You can install using the instant client option. I am … Continue reading Access Oracle tables from SQL Server 2005