RE: odbc for aix?
Date: Thu, 14 May 2015 15:46:52 +0000
Message-ID: <D18D6513433DF04394041EA42B53E91C9D1FC578_at_ICATMAIL1.ICAT.com>
Sadly, the gateway is not free. List price for Database Gateway for SQL Server is $17,500 USD per *computer* (not processor).
I am in complete agreement with the comment that sql server --> oracle is a cheaper and effective path to take (if possible). I don't know if it's easier since I have never had the luxury of using an oracle-supplied gateway. :)
-joe
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Jesse
Sent: Thursday, May 14, 2015 9:37 AM
To: oracle-l_at_freelists.org
Subject: Re: odbc for aix?
Patrice writes:
> I have been asked whether it is possible to connect Oracle on AIX to
> SQL Server.
>
> are there odbc drivers for AIX?
Yes, and google can help you there, but maybe Database Gateways (successor to Transparent Gateways) would be a more stable and/or supported method?
http://www.oracle.com/technetwork/database/gateways/index.html
IIRC, the license is included with the DB, but you'll need to check that...
Also, depending on what you need, going from SQueaL Server to Oracle is much simpler to do. Just install a compatible Oracle Client on the SQueaL Server server and use a Linked Server in SS. The driver then becomes SS instead of Oracle, if that's workable for your situation.
Rich
-- http://www.freelists.org/webpage/oracle-l Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you. -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 14 2015 - 17:46:52 CEST