Clever Geek Handbook

Connect SQL Server 2005 from Oracle

I am running Oracle and SQL SERVER 2oo5 on the same server. Plstform will win 2003 Enterprise. I have created a system DSN file. Make an entry in listener.ora and tnsnames.ora.

but when i go to ping my dsn system is not responding. and when I try to create a database link using my dsn it gives an error.

What to do? thanks for the help in advance.

Sunil

0


source to share


1 answer


You must:

-Create UDL file

-Install heterogeneous services ($ ORACLE_HOME \ hs \ admin) and create a file like initDATAB.ora

this with this content:

HS_FDS_CONNECT_INFO="UDLFILE=C:\\ccc\\SQLSERVER.udl

-Add an entry on listener.ora

on SID_LIST_LISTENER

as follows:

   (SID_DESC=
      (SID_NAME=DATAB)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
      (PROGRAM=hsolesql)
   )

-Create an entry on tnsnames.ora

:



SQLSERVERDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = riereta)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME=DATAB)
    )
    (HS=OK) 
  )

-Create a database link pointing to SQLSERVERDB

Links

- Oracle® Heterogeneous Connections Administrator's Guide

- Reference for Basic Oracle® Database Services

- CREATE DATABASE LINK in Oracle SQL Reference Database

+1


source






More articles:


All Articles