Linked server issue from SQL Server 2005 to Oracle
May 8th, 2007 — ¥ong¥s
“It is very troublesome to set up a link server to oracle”. I totally agree with that. Once you get any error from that, it is very hard to find out the actual problem out there. Here is a link that lists out steps to set up and troubleshoot a linked server to an Oracle database in SQL Server:
http://support.microsoft.com/kb/280106
If these steps do not able to solve your problem, you probably will stop at there. So far I do not find a better one online unless getting help for some guru.