connect with oracle

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  April 19, 2015 at 11:20 pm

  #307194

  Hi All,

  I need to create report using SSRS, where source is oracle. but I am not able to connect with oracle.

  I don't know how to config TNS? Please guide.

  Thanks

  Abhas.

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  April 23, 2015 at 9:22 am

  #1793032

  Hi,

  I am able to sort this issue. We need to add connection string in tnsnames.ora files.

  sample is as below:

  TEST =

  (DESCRIPTION =

  (ADDRESS_LIST =

  (ADDRESS = (PROTOCOL = TCP)(HOST = "hostname(eg. http://www.test.biz)")(PORT = "port(eg. 1520)"))

  )

  (CONNECT_DATA =

  (SERVICE_NAME = TEST)

  )

  )

  Thanks,

  Abhas