Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 14457 invoked from network); 8 Aug 2008 17:02:45 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 8 Aug 2008 17:02:41 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C462B8DF723; Fri, 8 Aug 2008 18:02:33 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01619-03-9; Fri, 8 Aug 2008 18:02:33 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E35B78DF7B2; Fri, 8 Aug 2008 18:02:32 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 08 Aug 2008 18:00:34 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A39128DF745 for ; Fri, 8 Aug 2008 18:00:34 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32679-02-3 for ; Fri, 8 Aug 2008 18:00:34 -0400 (EDT) Received: from web38206.mail.mud.yahoo.com (web38206.mail.mud.yahoo.com [209.191.124.149]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 515248DF735 for ; Fri, 8 Aug 2008 18:00:32 -0400 (EDT) Received: (qmail 35563 invoked by uid 60001); 8 Aug 2008 22:00:32 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=4RgrmAPQyzUmmdi0irIboeEUO5QcdYbALHK+YLTR93EkwF4LldjAA0Aj+mj/86ndypeKL9Z/QykYElAsFFoGCRCfZKHmauNX4yapP1AKRFvvIrNFoWdKbSQydEImDqz05Wx0zZjJxI1XQBo3lY+jghgcM8SB2vHhTHd0DE0Pvj4=; Received: from [216.136.115.130] by web38206.mail.mud.yahoo.com via HTTP; Fri, 08 Aug 2008 15:00:31 PDT Date: Fri, 8 Aug 2008 15:00:31 -0700 (PDT) From: kathy duret Subject: RE: connecting Oracle to SQL Server To: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1613232013-1218232831=:35467" Message-ID: <353316.35467.qm@web38206.mail.mud.yahoo.com> X-archive-position: 10018 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: katpopins21@yahoo.com Precedence: normal Reply-to: katpopins21@yahoo.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain --0-1613232013-1218232831=:35467 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable There are some free drivers available TDS is one I believe for Linux. =A0 Data direct will give you a 15 day trial then you have to cough up the $$ I didn't have any issues with the TDS driver for 32 bit in the past. =A0 HS works fairly well depending what you want to do. =A0 If you are on 64 bit you need to use dg4odbc for HS and that works with 10g= upward. For 10G you need to install the 11G gateway. =A0 You might want to play with DTS from the Sql Server side of things as well.= =A0 I haven't used it but we do use it at work and it works very well. =A0 K =A0 --- On Fri, 8/8/08, Powell, Mark D wrote: From: Powell, Mark D Subject: RE: connecting Oracle to SQL Server To: "Jeffrey Beckstrom" Cc: oracle-l@freelists.org Date: Friday, August 8, 2008, 2:15 PM =A0 The gateway product costs extra. =A0 HS or generic connectivity requires the use of an ODBC driver for the datab= ase server platform designed to access SQL Server.=A0 The only platform I b= elieve that comes with such a driver is Windows so extra cost is probably r= equired unless you are capable of writing your own ODBC program. =A0 On the other hand the Oracle client for Windows is free and MS on 32 bit sy= stems provides ODBC/OLE drivers to Oracle.=A0 For 64 bit Windows you need t= he Oracle 64 bit OLE driver.=A0 Pushing and pulling from the SQL Server sid= e is free. =A0 -- Mark D Powell --=20 Phone (313) 592-5148=20 =A0 From: Jeffrey Beckstrom [mailto:JBECKSTROM@gcrta.org]=20 Sent: Friday, August 08, 2008 3:01 PM To: Powell, Mark D Subject: RE: connecting Oracle to SQL Server Are they extra costs options? >>> "Powell, Mark D" 8/8/08 2:48 PM >>> =A0 Look into Generic Connectivity and Heterogeneous Services on metalink.=A0 A= lso the Oracle product: Transparent Open Gateway. =A0 -- Mark D Powell --=20 Phone (313) 592-5148=20 =A0 From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Jeffrey Beckstrom Sent: Friday, August 08, 2008 1:54 PM To: oracle-l-freelists; oracle-db-l Subject: connecting Oracle to SQL Server Isn't possible to access a SQL Server database from within an Oracle databa= se.=A0 If true, can someone point me in the right direction. =A0 =A0Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 --------------------------------------------------------------------- Scanning=A0of=A0this=A0message=A0and=A0addition=A0of=A0this=A0footer=A0is= =A0performed by=A0SurfControl=A0E-mail=A0Filter=A0software=A0in=A0conjunction=A0with=A0 virus=A0detection=A0software. =0A=0A=0A --0-1613232013-1218232831=:35467 Content-Type: text/html; charset=us-ascii

There are some free drivers available TDS is one I believe for Linux.
 
Data direct will give you a 15 day trial then you have to cough up the $$
I didn't have any issues with the TDS driver for 32 bit in the past.
 
HS works fairly well depending what you want to do.
 
If you are on 64 bit you need to use dg4odbc for HS and that works with 10g upward.
For 10G you need to install the 11G gateway.
 
You might want to play with DTS from the Sql Server side of things as well.  I haven't used it but we do use it at work and it works very well.
 
K
 

--- On Fri, 8/8/08, Powell, Mark D <mark.powell@eds.com> wrote:
From: Powell, Mark D <mark.powell@eds.com>
Subject: RE: connecting Oracle to SQL Server
To: "Jeffrey Beckstrom" <JBECKSTROM@gcrta.org>
Cc: oracle-l@freelists.org
Date: Friday, August 8, 2008, 2:15 PM

 
The gateway product costs extra.
 
HS or generic connectivity requires the use of an ODBC driver for the database server platform designed to access SQL Server.  The only platform I believe that comes with such a driver is Windows so extra cost is probably required unless you are capable of writing your own ODBC program.
 
On the other hand the Oracle client for Windows is free and MS on 32 bit systems provides ODBC/OLE drivers to Oracle.  For 64 bit Windows you need the Oracle 64 bit OLE driver.  Pushing and pulling from the SQL Server side is free.
 
-- Mark D Powell --
Phone (313) 592-5148
 

From: Jeffrey Beckstrom [mailto:JBECKSTROM@gcrta.org]
Sent: Friday, August 08, 2008 3:01 PM
To: Powell, Mark D
Subject: RE: connecting Oracle to SQL Server

Are they extra costs options?

>>> "Powell, Mark D" <mark.powell@eds.com> 8/8/08 2:48 PM >>>
 
Look into Generic Connectivity and Heterogeneous Services on metalink.  Also the Oracle product: Transparent Open Gateway.
 
-- Mark D Powell --
Phone (313) 592-5148
 

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Jeffrey Beckstrom
Sent: Friday, August 08, 2008 1:54 PM
To: oracle-l-freelists; oracle-db-l
Subject: connecting Oracle to SQL Server

Isn't possible to access a SQL Server database from within an Oracle database.  If true, can someone point me in the right direction.
 
 
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113



---------------------------------------------------------------------


Scanning of this message and addition of this footer is performed
by SurfControl E-mail Filter software in conjunction with 
virus detection software.


--0-1613232013-1218232831=:35467-- -- http://www.freelists.org/webpage/oracle-l