From: "Taylor, Chris David" <ChrisDavid.Taylor@ingrambarge.com>
To: "'Brian.Zelli@RoswellPark.org'" <Brian.Zelli@RoswellPark.org>
CC: 'Oracle L' <oracle-l@freelists.org>
Date: Wed, 9 Sep 2009 13:29:58 -0500
Subject: RE: Oracle to SQL Server
Thread-Topic: Oracle to SQL Server
Message-ID: <C5533BD628A9524496D63801704AE56D368098A1A2@SPOBMEXC14.adprod.directory>
References: <6B3493ABEE194842A8EFC3FC3B23DE6A107C8F9027@MSXMBCCR2.roswellpark.org> <dede63360909091018s45e6fff0w7aa91031bf2d0ac0@mail.gmail.com>,<6B3493ABEE194842A8EFC3FC3B23DE6A107C8F902E@MSXMBCCR2.roswellpark.org> <4814386347E41145AAE79139EAA398980C71FCDA4F@ws03-exch07.iconos.be>
In-Reply-To: <4814386347E41145AAE79139EAA398980C71FCDA4F@ws03-exch07.iconos.be>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: ChrisDavid.Taylor@ingrambarge.com

About 3 years ago (4 now maybe?) I had HSODBC working on Linux to Windows SqlServer.

If I remember correctly I used UnixODBC (but not positive).  Might have used FreeTDS as well but its been a while.

CAVEAT:  IF you are using 9i, then you have to use a 10g (or newer) listener as the listener controls/interfaces with the HSODBC connectivity - the 9i HSODBC is a no-go on RHEL.  Once you have the 10g listener, and HSODBC setup, the connectivity works but it does take some time to get familiar with it and set it up and then tweak it.

 
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@ingrambarge.com
 

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.


-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of D'Hooge Freek
Sent: Wednesday, September 09, 2009 1:19 PM
To: Brian.Zelli@RoswellPark.org; 'Igor Neyman'
Cc: Oracle L
Subject: RE: Oracle to SQL Server

Not to sql server but we did a setup to postgresql for a client 2 weeks ago.
Have a look at metalink note 245549.1 - How to setup Generic Connectivity -  HSODBC -  on SUN Solaris

Freek D'Hooge
Uptime
Oracle Database Administrator
e-mail: freek.dhooge@uptime.be
tel. +32 (0)3 451 23 82
http://www.uptime.be
disclaimer


From: oracle-l-bounce@freelists.org [oracle-l-bounce@freelists.org] On Behalf Of Zelli, Brian [Brian.Zelli@RoswellPark.org]
Sent: 09 September 2009 20:05
To: 'Igor Neyman'
Cc: Oracle L
Subject: RE: Oracle to SQL Server


Has anyone been successful at going from unix to windows doing this?

ciao,
Brian


From: Igor Neyman [mailto:igor.neyman@gmail.com]
Sent: Wednesday, September 09, 2009 1:18 PM
To: Zelli, Brian
Cc: Oracle L
Subject: Re: Oracle to SQL Server


Brian,

Take a look at Heterogeneous Services in Oracle docs.

Igor


On Wed, Sep 9, 2009 at 1:12 PM, Zelli, Brian <Brian.Zelli@roswellpark.org> wrote:

Hello all,
   A manager just asked me to make a connection from oracle to sql server and wants a view created from sql server data.  I've gone the other way but never from oracle to sql server.  I did a quick google and some things didn't seem clear.  Can anybody point me in the right direction?


ciao,
Brian


This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.


This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
--
http://www.freelists.org/webpage/oracle-l


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