Oracle-L: RE: Connecting to Non Oracle databases from Oracle

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 05 Feb 2003 06:52:55 -0800
Message-ID: <F001.0054432C.20030205065255@fatcity.com>

Sunil - I believe your method will allow you to connect from the non-Oracle DB to Oracle. I don't believe it will allow you to do the opposite, but your subject line says "from Oracle". So I think you will need another method. Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
[mailto:Sunil.Kumar.Gompa_at_ercgroup.com]
Sent: Wednesday, February 05, 2003 3:59 AM To: Multiple recipients of list ORACLE-L

Hi,

I am trying to connect to a Non Oracle database from the Oracle database ( Version 8.1.7.4).
i want to do some thing like this :
i have my ODBC set up on an Win NT machine. I have created a heterogeneous connection set up on Win NT.
Now i want to connect from a Unix machine to the Listener entry that i have done on the Win NT server, there by connecting to the Non Oracle database.

SqlServer -------odbc setup on NT--------> Win NT ( LIstener Entry: pubs)
--------> Unix (Tnsnames entry : pubs.world)

can this be done ??

Regards,
Sunil Gompa

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Sunil.Kumar.Gompa_at_ercgroup.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Feb 05 2003 - 08:52:55 CST