If you're using the gateway it's only available on microsoft. If you use HS it can sit on unix but you need an odbc driver. There was an article on metalink that I followed and I got it to work. I used an odbc driver from www.datadirect.com Mike ganstadba@xxxxxxxxxxx ----- Original Message ----- From: "Smith, Ron L." <rlsmith@xxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Monday, May 03, 2004 2:59 PM Subject: Connection between Oracle on Unix and SQL Server > I need to implement a connection between Oracle on Unix and SQL Server. > I have tried both Transparent Gateway and Heterogeneous Services but I > have had not luck with either. This is a low volume connection that > will be used on several different servers to various applications. =20 > > Does anyone know where I can get some fool proof (in this case idiot > proof) instructions on how to set up this type of connection? > > Thanks! > Ron Smith > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------