I'm trying to set up a linked server in SQL Server to an Oracle 10 server.
I've been reading and re-reading the MSDN doc on sp_addlinkedserver, but it's not clicking. I'm not using TNS, so I need to provide the server name in one of the variables there, but I can't tell where.
Unfortunately, it isn't clear. For instance, @server is not the name of the server to connect to, but it's just an arbitrary name that you see in the management studio. The @srvproduct is just a label.
The important information that the linked server needs is the host, the engine and maybe the database, but I can't tell where to pass those in at.
I read and re-read all those examples over and over, but I'm not seeing how to make this work.