I am trying to create a linked server on my MS SQL Server 2008 to an Oracle 10.2.0.4.0 database. They are on two different boxes but on the same domain. I have no experience with Oracle so any suggestions please be very specific. I have tried installing the Oracle 11g client on my SQL Server box but i'm kind-of lost as to what to do next. I'm unsure of the name of my Oracle "Service" and not quite sure how to find that. Thanks in advance. Also, both servers are running Windows 7 Pro.