From oracle-l-bounce@freelists.org Thu Sep 29 12:29:20 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8THTKM5021297 for ; Thu, 29 Sep 2005 12:29:20 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8THTA6H021274 for ; Thu, 29 Sep 2005 12:29:16 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0582C1EFF12; Thu, 29 Sep 2005 12:29:04 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28644-07; Thu, 29 Sep 2005 12:29:03 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E8B861EFE9B; Thu, 29 Sep 2005 12:29:02 -0500 (EST) x-mimeole: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5C51A.F380787B" Subject: RE: Oracle Transparent Gateway Date: Thu, 29 Sep 2005 11:26:39 -0600 Message-ID: <61C20FAEF5CD8F419340F43E6AF5A95F01228759@COENGEXCMB01.cable.comcast.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Oracle Transparent Gateway Thread-Index: AcXFFFIMNUgC7rv4Rjm5MYfgtlFTrwABl+/g From: "Pass, Stephanie" To: , X-OriginalArrivalTime: 29 Sep 2005 17:26:40.0693 (UTC) FILETIME=[F4360650:01C5C51A] X-archive-position: 26117 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Stephanie_Pass@cable.comcast.com Precedence: normal Reply-To: Stephanie_Pass@cable.comcast.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.6 required=5.0 tests=BAYES_00,HTML_60_70, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5C51A.F380787B Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Why not use a db-link in oracle, OLEDB or ODBC connectivity and a linked = server on the sql server side? Will be a lot cheaper than trying to use = OTG. =20 -----Original Message----- From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org]On Behalf Of Subbiah, Nagarajan Sent: Thursday, September 29, 2005 10:39 AM To: 'oracle-l@freelists.org' Subject: Oracle Transparent Gateway =20 Hi, =20 Is the Oracle Transparent Gateway a licensable product? We have a = requirement to access the SQL Server from the Oracle using the DB link = or Synonyms of the SQL Server object in the Oracle using the dblink.=20 =20 In the Heterogeneous connectivity document, it says either you could use = the Generic connectivity or the Transparent Gateway. The transparent = gateway can use the SQL Server database as a another Oracle database so = we could use the Database link. How about the Generic connectivity? I = wasn't clear that the Generic connectivity has the same feature of using = the db link. Also, Does Oracle support the SQL Server connectivity from = the Unix (HP-UX)? =20 Thanks, Raja ------_=_NextPart_001_01C5C51A.F380787B Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message

Wh= y not use a db-link in oracle, OLEDB or ODBC connectivity and a linked server = on the sql server side?  Will be = a lot cheaper than trying to use OTG.

 

-----Original Message-----
From: = oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Subbiah, Nagarajan
Sent: Thursday, September = 29, 2005 10:39 AM
To: = 'oracle-l@freelists.org'
Subject: Oracle = Transparent Gateway

 

Hi,= <= /p>

 <= /p>

Is the Oracle = Transparent Gateway a licensable product? We have a requirement to access the SQL = Server from the Oracle using the DB link or Synonyms of the SQL Server object = in the Oracle using the dblink. <= /p>

 <= /p>

In the = Heterogeneous connectivity document, it says either you could use the Generic = connectivity or the Transparent Gateway. The transparent gateway can use the SQL Server database as a another Oracle database so we could use the Database link. = How about the Generic connectivity? I wasn't clear that the Generic connectivity has the same feature of using the db link. Also, Does = Oracle support the SQL Server connectivity from the Unix = (HP-UX)?<= /p>

 <= /p>

Thanks,<= /p>

Raja<= /p>

------_=_NextPart_001_01C5C51A.F380787B-- -- http://www.freelists.org/webpage/oracle-l