RE: MS SQL Server ODBC Driver for Linux, HPUX

From: Subbiah, Nagarajan <Nagarajan.Subbiah_at_aetn.com>
Date: Wed, 10 Jun 2009 10:20:06 -0400
Message-ID: <5598918403BB9F45ABC407657DDB7FF310EC2F94_at_exch2k3.aetvn.com>

Using DataDirect, we had done some evaluation in the past. Performance was great and no significant problems with that we could find.  

We couldn't implement as the focus was shifted towards EAI with webservices/SOA design, so no database to database direct communication using db link or any other drivers :(  

Raja.

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of kathy duret
Sent: Tuesday, June 09, 2009 5:28 PM
To: oracle-l_at_freelists.org
Subject: RE: MS SQL Server ODBC Driver for Linux, HPUX

I assume you are on 32 bit. There is free TDS which works fine. Try that out and if your mileage varies try use the 15 day trial with Data Direct (works fairly well). There is also one out my Merant (spelling questionable) that works as well but I thought it a bit pricey.  

I was on 64 bit and had to use a IBM driver which worked out well.  

Kathy

• On Tue, 6/9/09, Sweetser, Joe <JSweetser_at_icat.com> wrote:

	From: Sweetser, Joe <JSweetser_at_icat.com>
	Subject: RE: MS SQL Server ODBC Driver for Linux, HPUX
	To: japplewhite_at_austinisd.org, "Oracle-l"
<oracle-l_at_freelists.org>
	Cc: oracle-l-bounce_at_freelists.org
	Date: Tuesday, June 9, 2009, 3:27 PM
	
	
	Oracle seems to recommend (though not exclusively) the driver

from datadirect.com.          

        Metalink Note 466228.1 has this in it:          

        The ODBC driver

                There are several ODBC vendors for UNIX platforms. Below is a description using the ODBC driver from Data Direct Technologies. They also provide a 15 day trial license for Linux based platforms. More information is available at the following URL:

                http://www.datadirect.com          

        hth,

        -joe

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
japplewhite_at_austinisd.org
Sent: Tuesday, June 09, 2009 2:01 PM
To: Oracle-l
Cc: oracle-l-bounce_at_freelists.org
Subject: MS SQL Server ODBC Driver for Linux, HPUX

Anyone have a recommendation? We're getting more and more SQL Server databases and are needing to access them from our Oracle DBs on Linux and HPUX. My associate, who, thank God, is a SQL Server guru, has gotten one (that our Sys Admins found) set up and working with 9i Heterogeneous Services on an HPUX server. It's one from EasySoft and we're investigating the costs. A brief scan of SourceForge didn't reveal much that looked promising. Did I miss one? Any others?

Thanks.

Jack C. Applewhite - Database Administrator Austin I.S.D. - MIS Department
512.414.9715 (wk) / 512.935.5929 (pager)

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

Received on Wed Jun 10 2009 - 09:20:06 CDT