0 Replies Latest reply: May 2, 2012 8:57 AM by 934314 RSS

    sql server - oracle database problem

    934314
      I am trying to make a connection from an Oracle database installed on a server with a linux OS to a Sql server on my local computer.
      I have installed an OWB client 10g on my local computer where I have my SQL Server.
      I have started by creating a dns for a sql server on my local computer called sqlserver.
      I have modified the listener.ora file from the server by creating a new listener:
      odbc_listener =
      (ADDRESS=(PROTOCOL = TCP) (HOST = oracle_host )
      (PORT=1522))

      SID_LIST_ODBC_LISTENER=
      (SID_DESC=
      (SID_NAME=sqlserver)
      (ORACLE_HOME= oracle_home )
      (PROGRAM=hsodbc)
      )

      I have added a new entry in the tnsnames.ora file in the database network/admin folder:
      sqlserver=
      (DESCRIPTION=
      (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=TCP)
      (HOST = local pc ip ) (PORT=1522)
      (CONNECT_DATA=
      (SID=sqlserver))
      (HS=OK)
      )

      I have also created an initsqlserver.ora file in hs/admin folder in the oracle database where I have specified the name for de DSN
      HS_FDS_CONNECT_INFO = sqlserver
      HS_FDS_TRACE_LEVEL = 0

      Still, I can't create a successful ODBC location from the OWB i have installed on my local computer. I get the typical Oracle connection error.
      Is there anything else I have to modify in order to make this connection possible?
      I don't understand very well how can a remote database connect to a local sql server using just that dsn.

      Edited by: 931311 on 02.05.2012 06:53

      Edited by: 931311 on 02.05.2012 06:56

      Edited by: 931311 on 02.05.2012 06:56