Linked Server from SQL 2008 to Oracle needs port #

• mvallone

  SSC Rookie

  Points: 29

  More actions

  March 1, 2016 at 11:51 am

  #305218

  I'm trying to figure out how to create a linked server on SQL 2008r2 to an Oracle db. I have a server name (not an IP address) and all of the information. When I try connecting I timeout. I believe this is caused by the fact I don't have the port # in the definition of the linked server.

  Is there a way to include a port # in a linked server definition on SQL 2008r2 going to an Oracle db?

  Thanks.

• Jo Pattyn

  SSC-Dedicated

  Points: 32070

  More actions

  March 3, 2016 at 3:18 am

  #1862671

  Not sure.

  I usually go with the TNS-alias of the oracle server, with the servername and port in tnsnames.ora.