Re: Database Gateway for ODBC

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)
>
>
>

--
http://www.freelists.org/webpage/oracle-l