RE: connecting Oracle to SQL Server

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Fri, 8 Aug 2008 15:15:34 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A902B8C109@usahm208.amer.corp.eds.com>

 

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_at_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_at_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_at_freelists.org
[mailto:oracle-l-bounce_at_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.         

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 08 2008 - 14:15:34 CDT