Re: Database Gateway for ODBC
- From: Yechiel Adar <adar666@xxxxxxxxxxxx>
- Date: Thu, 24 Jul 2008 08:13:22 +0300
I see you use HS.
You need to:
1) Create a listener for this HS.
2) Create system dsn in start->system tools->odbc..
3) Create init.ora for this HS connection under hs\asmin.
4) create dblink for the connection.
http://www.datadirect.com/developer/odbc/oracle_heterogeneous/index.ssp
will be a good place to start.
Adar Yechiel
Rechovot, Israel
Shanmugam, Dhandapani wrote:
Hi,
bash[]> tnsping DHAN
TNS Ping Utility for Solaris: Version 10.2.0.3.0 - Production on
21-JUL-2008 07:11:32
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
/var/opt/oracle/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP) (HOST = corpsify.corp.sify.com) (PORT = 1521)))
(CONNECT_DATA = (SID= DHAN)) (HS=OK))
OK (0 msec)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
