Home » RDBMS Server » Networking and Gateways » Database link form oracle10g to sqlserver
Database link form oracle10g to sqlserver [message #287186] Tue, 11 December 2007 06:22 Go to next message
DRASTANT
Messages: 21
Registered: July 2007
Location: KENYA
Junior Member
"vedamta"
hi all,
I am trying to create a link from oracle 10g to sql serever but not successful
i have created a dsn for sql server on local machine
my new tnsnames.ora looks like this

bst =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aaa)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = bst)
)
)

ast =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aaa)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ast)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

msql =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(host=abcd)(port=1433))
)
(CONNECT_DATA =
(SID = msql)
)
(HS=OK)
)

and listener.ora looks like this

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = aaa)(PORT = 1433))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

SID_LIST_LISTENERMSQL =
(SID_LIST =
(SID_DESC =
(SID_NAME = MSQL)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = hsodbc)
)
)

LISTENERMSQL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = abcd)(PORT = 1433))
)


when i tns ping ast or bst it is working fine
but when i tnsping msql (sql server ) it gives error
TNS-12537: TNS:connection closed
and i cannot even see the service handlers in
listener stauts

please guide me
Re: Database link form oracle10g to sqlserver [message #287187 is a reply to message #287186] Tue, 11 December 2007 06:24 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

AFAIK, you can't create database link from oracle db to sql server.
Re: Database link form oracle10g to sqlserver [message #287273 is a reply to message #287187] Tue, 11 December 2007 15:09 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
However, you might try with the Oracle heterogeneous service ODBC agent. Here is a walkthrough; perhaps you'll find it useful.
Previous Topic: Oracle Connectivity Error
Next Topic: How to connect oracle db by OracleConnection?
Goto Forum:
  


Current Time: Thu Mar 28 18:25:34 CDT 2024