RE: Connecting to Non Oracle databases from Oracle

i was successfull in connecting to a Non oracle database from Oracle on unix through the Listener on Win NT.
this situation arose b'cos we did not have a ODBC setup on Unix. So we had to do the ODBC as well as the Heterogeneous services setup on Win NT. and then try to connect from databse on Unix machine to this Listener on NT.

Regards,
Sunil Gompa

-----Original Message-----
Sent: Wednesday, February 05, 2003 3:05 PM To: Sunil.Kumar.Gompa_at_ercgroup.com; Multiple recipients of list ORACLE-L

NO, you have to do it the otherway around with Heterogenous services. Namely ODBC on the Unix platform.

Dick Goulet

____________________Reply Separator____________________
Author: Sunil.Kumar.Gompa_at_ercgroup.com
Date:       2/5/2003 1:58 AM

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