Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h160NW920912 for ; Wed, 5 Feb 2003 18:23:32 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h160NVQ20904 for ; Wed, 5 Feb 2003 18:23:31 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id NAA21995; Wed, 5 Feb 2003 13:07:22 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0054456F; Wed, 05 Feb 2003 08:09:32 -0800 Message-ID: Date: Wed, 05 Feb 2003 08:09:32 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Sunil.Kumar.Gompa@ercgroup.com Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Sunil.Kumar.Gompa@ercgroup.com Subject: RE: Connecting to Non Oracle databases from Oracle Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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@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@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@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@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@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@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).